SQL LOG10 Function

The SQL Server LOG10 function is a Mathematical function that calculates the base 10 logarithmic value of the given float value and its syntax is

SELECT LOG10 (Float_Expression)
FROM [Source]

SQL LOG10 Function Example

The LOG10 Function is useful to calculate the logarithmic value of a given float value with the user-specified base value. In this example, We are going to check the same with different data and display the output.

DECLARE @i float
SET @i = 10

SELECT LOG10(@i)AS [LOG10 Result 1]

-- Calculating it directly
SELECT LOG10(1) AS [LOG10 Result 2]

SELECT LOG10(62.9876) AS [LOG Result 3]

SELECT LOG10(120.85 + 213.17 - 220.50 + 15.09) AS [LOG10 Result 4]

Within this SQL Server LOG10 Function example query, we are calculating the logarithmic value of @i base 10.

Next, we used the function directly on the SQL Server float values.

LOG10 Example 2

Here, We will calculate the base 10 logarithmic value of all the records present in the [DealerPrice] and [Tax Amount] using the LOG10 Mathematical function.

SELECT [EnglishProductName]
      ,[Color]
      ,[StandardCost]
      ,[ListPrice]
      ,[DealerPrice]
      ,LOG10([DealerPrice]) AS [Dealer_Log result]
      ,[SalesAmount]
      ,[TaxAmt]
      ,LOG10([TaxAmt]) AS [Tax_Log result]
  FROM [Prod Sales]