Skip to content
Related Articles

Related Articles

LOG10() Function in SQL Server
  • Last Updated : 29 Sep, 2020

This function returns the logarithm of a number to base 10.

Syntax :

LOG10(number)

Parameter :
This method accepts a single-parameter as mentioned above and described below.

  • number –
    This parameter hold a number which is greater than 0.

Returns –
It returns the base-10 logarithm of the specified number.

Let’s consider the following examples.
Example-1 :



SELECT LOG10(1) Result;

Output :

Result
0

Example-2 :

SELECT LOG10(10) Result;

Output :

Result
1

Example-3 :
Return the base-10 logarithm of 10.

SELECT LOG10(10);

Output :

1.0

Example-4 :
Return the base-10 logarithm of 1.

SELECT LOG10(1);

Output :

0.0

Example-5 :
When the argument passing as an expression.

SELECT LOG10(2 * 3);

Output :

0.77815125038364363
My Personal Notes arrow_drop_up
Recommended Articles
Page :