The SQL LOG10 function is one of the SQL Mathematical function which is used to calculate the base 10 logarithmic value of the given float value. In this article we will show you, How to use SQL Server LOG10 function with example.
SQL LOG10 Function Syntax
The basic syntax of the SQL Server LOG10 Function is as shown below:
|
1 2 |
SELECT LOG10 (Float_Expression) FROM [Source] |
SQL LOG10 Function Example 1
The SQL server LOG10 Function is used to calculate the logarithmic value of given float value with user specified base value. In this example, We are going to check the same with different data and display the output
T-SQL CODE
|
1 2 3 4 5 6 7 8 9 10 11 |
DECLARE @i float SET @i = 10 SELECT LOG10(@i)AS [LOG10 Result 1] -- Calculating LOG 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] |
OUTPUT
ANALYSIS
Below lines of code is used to declare float variable and assigning the random value.
|
1 2 |
DECLARE @i float SET @i = 10 |
Next, we are calculating the logarithmic value of @i base 10. We also assigned new name to the result as ‘LOG10 Result 1’ using SQL ALIAS Column.
|
1 |
SELECT LOG10(@i)AS [LOG10 Result 1] |
In the below statement, We used LOG10 function directly on the float values
|
1 2 3 |
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] |
SQL LOG10 Function Example 2
In this example, We are going to calculate the base 10 logarithmic value of all the records present in the [DealerPrice] and [Tax Amount] using LOG10 Function.
T-SQL CODE
|
1 2 3 4 5 6 7 8 9 10 |
SELECT [EnglishProductName] ,[Color] ,[StandardCost] ,[ListPrice] ,[DealerPrice] ,LOG10([DealerPrice]) AS [Dealer_Log result] ,[SalesAmount] ,[TaxAmt] ,LOG10([TaxAmt]) AS [Tax_Log result] FROM [SQL Tutorial].[dbo].[Prod Sales] |
OUTPUT
Thank You for Visiting Our Blog
Leave a Reply