LOG10

MySQL

LOG10(X)

• x: The numerical value whose base 10 logarithm will be computed. This value must be greater than zero.

Example

SELECT LOG10(1000) AS Logarithm_Base_10;

Output

3

Explanation

In the provided example, the LOG10() function in MySQL is used to calculate the base-10 logarithm of the number 1000. The output shows that the base-10 logarithm of 1000 is 3.

SQL Server

LOG10( float_expression )

• float_expression: This is the positive numeric expression for which the base-10 logarithm is to be calculated. LOG10 returns NULL if float_expression is negative. It returns an error if float_expression is zero.

Example

SELECT LOG10(1000) AS LogarithmBase10;

Output

 LogarithmBase10
----------------
 3

Explanation

In this example, LOG10(1000) function provides the base 10 logarithm of 1000, which is 3.

Oracle

LOG10(n NUMBER) RETURN NUMBER;

• n: This parameter represents the numeric value for which the base 10 logarithm is to be computed.

Example

SELECT LOG(10, 1000) FROM dual;

Output

3

Explanation

In this example, the LOG function in Oracle is used to find the base 10 logarithm of 1000. The result is 3 because 10 raised to the power of 3 is equal to 1000.