LN

This article will guide you on how to use the LN() function with its syntax and examples.

Overview

LN() will return the exponential value of its argument, which is recognized as the input parameter's natural logarithm.

Syntax

The syntax of the LN() function is described as follows.

LN (x)

x:  A positive or a negative number (or an expression that evaluates to a number).

Examples

Case #1: Basic LN() function

The example below shows that LN() function will return the natural logarithm of the number 7,87653.

SELECT LN(7.87653);

The final result is as follows.

+-------------+
| f           |
+-------------+
| 2.0638874   |
+-------------+

Case #2: Using LN() Function With a Table

In the following example, we will combine LN() function with CREATE TABLE query. Therefore we can obtain natural logarithmic values of a specific column.

1) Create a new table named LNTable containing the initValue column with an integer value.

CREATE TABLE LNtable(initValue int);
INSERT INTO LNtable(initValue)
VALUES (75), (18), (28);

2) Run the following query to get the logarithm output of the column:

SELECT * ,LN(initValue) AS lnValue FROM LNtable;

3) It will return the initial value with its natural logarithm value.

• initValue column with the initial integer values.
• lnValue column with the natural logarithm values.

+------------+---------------------------+
| initValue  | lnValue                   |
+------------+---------------------------+
| 75         | 4.31748811353631          |
| 18         | 2.8903717578961645        |
| 28         | 3.332204510175204         |
+------------+---------------------------+