SQL LOG()

The LOG() function in SQL returns the natural logarithm of a given number, or the logarithm of the number to the specified base.

Syntax

LOG(number)

LOG(base,number)

Copy to clipboard
Copy to clipboard

The input value number refers to the value for which you want to calculate the logarithm. The number must be a positive real number greater than 0. It represents the value you want to find the exponent for.

The input value base represents the number to which the logarithm is being calculated. It determines the scale of the logarithm. The base must be a positive real number greater than 0, except for 1. The logarithm calculates the exponent to which the base must be raised to obtain the given number.

Example 1

In this example, the following data is given in the table_1 table:

The LOG() function is used to calculate the natural logarithm of each value in the number column:

SELECT number, LOG(number) AS log_num
FROM table_1;

Copy to clipboard
Copy to clipboard

The output will be:

Example 2

In this example, the following data is given in the table_2 table:

The LOG() function is used to calculate the logarithm of the number value to the base value:

SELECT base,number,LOG(base,number) AS log_num
FROM table_2;

Copy to clipboard
Copy to clipboard

The output will be:

Note: LOG() is compatible with various SQL database systems such as MySQL, PostgreSQL, Oracle, and SQL Server.