LN function

The LN function is an alias for the LOGN function, and returns the natural logarithm of a numeric argument. This value is the inverse of the exponential value.

Read syntax diagramSkip visual syntax diagram
LN Function

|--LN--(--float_expression--)-----------------------------------|

The following query returns the natural logarithm of population for each row in the history table:
SELECT LN(population) FROM history WHERE country='US'
   ORDER BY date; 

Copyright© 2021 HCL Technologies Limited