# SQL Log10 Function: Complete Guide

0
3 SQL log10 () function is used for returning the natural logarithm of a number to its base 10.

## SQL log10

The LOG10() is a built-in SQL function that returns the natural logarithm of a number to base 10.

### Syntax

```SELECT LOG10 (Number)
```

### Parameters

Number: The number whose logarithmic value is to be calculated. Its value should be greater than 0.

### Example

#### Query 1

```Select Log10 (1);
```

```0.0
```

#### Query 2

```Select Log10 (96);
```

#### Output

```1.9822712330395684
```

#### Query 3

```Select Log10 (10.90+15.10-22.50+1.50);
```

#### Output

```0.69897000433601886
```

#### Explanation

Here, we have directly applied the log function on the float values.

#### Query 4

```Select Log (10, 4);
```

#### Output

```0.6989700043360187
```

#### Explanation

Here 10 is the base and 4 is the number.

Similarly, it can be written as Log10 (4).

#### Query 5

```SELECT POWER (10, LOG10 (5));
```

`5`

#### Explanation

It returned the result of raising a base-10 logarithm to a specified power.

#### Query 6

```SELECT LOG10 (-1);
```

#### Output

```An invalid floating point operation occurred.
```

#### Explanation

This message was displayed because this function returns the value for only those numbers which are positiTherefore, it. It gives an error like above.

#### Query 7

```SELECT LOG10 (0);
```

#### Output

An invalid floating point operation occurred.

#### Explanation

Here, 0 was passed as an argument, so the same message was displayed which was displayed previously.

## SQL Server log10()

In SQL Server, the T-SQL LOG10() function is a mathematical function that returns the base-10 logarithm of the specified float expression.

#### Query 1

`SELECT LOG10(10) Result;`

`1`