LN

7min

Overview
LN() will return the exponential value of its argument, which is recognized as the input parameter's natural logarithm. 
The logarithm doesn’t take negative numbers or 0.
Syntax
The syntax of the LN() function is described as follows.
Syntax
LN (x)
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
SELECT LN(7.87653);
SELECT LN(7.87653);
﻿
The final result is as follows.
Output
+-------------+
| f           |
+-------------+
| 2.0638874   |
+-------------+
+-------------+
| 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 a table
CREATE TABLE LNtable(initValue int);
INSERT INTO LNtable(initValue)
VALUES (75), (18), (28);
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
SELECT * ,LN(initValue) AS lnValue FROM LNtable;
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.
Output
+------------+---------------------------+
| initValue  | lnValue                   |
+------------+---------------------------+
| 75         | 4.31748811353631          |
| 18         | 2.8903717578961645        |
| 28         | 3.332204510175204         |
+------------+---------------------------+
+------------+---------------------------+
| initValue  | lnValue                   |
+------------+---------------------------+
| 75         | 4.31748811353631          |
| 18         | 2.8903717578961645        |
| 28         | 3.332204510175204         |
+------------+---------------------------+
﻿
﻿

Updated 09 Oct 2023

Did this page help you?

FLOOR

SIN

Docs powered by Archbee

TABLE OF CONTENTS

Overview

Syntax

Examples

Case #1: Basic LN() function

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