`log10({n})`

Returns the base 10 logarithm of a number n. The value n can be any positive, non-zero numeric value in the range 0 < n <= 1.797e308.

log10({n}) takes the following syntax.

1SELECT log10(NUMERIC_VALUE) as ALIASNAME
2FROM DATASET;

Example

This example returns the base 10 logarithm for the number 5.

1SELECT log10(5) as logExample FROM Superstore
2LIMIT 1;

logExample
0.698