Example
Return the base-10 logarithm of 2:
SELECT LOG10(2);
Definition and Usage
The LOG10() function returns the natural logarithm of a number to base 10.
Note: Also look at the LOG() function.
Syntax
LOG10(number)
SQL LOG Function
Example
Return the natural logarithm of 2:
SELECT LOG(2);
Definition and Usage
The LOG() function returns the natural logarithm of a specified number, or the logarithm of the number to the specified base.
From SQL Server 2012, you can also change the base of the logarithm to another value by using the optional base parameter.
Note: Also look at the EXP() function.
Syntax
LOG(number, base) — Syntax for SQL Server
OR :
LOG(number) — Syntax for Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse
SQL FLOOR Function
Example
Return the largest integer value that is equal to or less than 25.75:
SELECT FLOOR(25.75) AS FloorValue;
Definition and Usage
The FLOOR() function returns the largest integer value that is smaller than or equal to a number.
Tip: Also look at the CEILING() and ROUND() functions.
Syntax
FLOOR(number)
SQL EXP Function
Example
Return e raised to the power of 1:
SELECT EXP(1);
Definition and Usage
The EXP() function returns e raised to the power of a specified number.
The constant e (2.718281…), is the base of natural logarithms.
Note: See also the LOG() function.
Syntax
EXP(number)
SQL DEGREES Function
Example
Convert a radian value into degrees:
SELECT DEGREES(1.5);
Definition and Usage
The DEGREES() function converts a value in radians to degrees.
Note: See also the RADIANS() and PI() functions.
Syntax
DEGREES(number)
SQL COT Function
Example
Return the cotangent of a number:
SELECT COT(6);
Definition and Usage
The COT() function returns the cotangent of a number.
Syntax
COT(number)
SQL COS Function
Example
Return the cosine of a number:
SELECT COS(2);
Definition and Usage
The COS() function returns the cosine of a number.
Syntax
COS(number)
SQL COUNT Function
Example
Return the number of products in the “Products” table:
SELECT COUNT(ProductID) AS NumberOfProducts FROM Products;
Definition and Usage
The COUNT() function returns the number of records returned by a select query.
Note: NULL values are not counted.
Syntax
COUNT(expression)
SQL CEILING Function
Example
Return the smallest integer value that is greater than or equal to a number:
SELECT CEILING(25.75) AS CeilValue;
Definition and Usage
The CEILING() function returns the smallest integer value that is larger than or equal to a number.
Tip: Also look at the FLOOR() and ROUND() functions.
Syntax
CEILING(number)
SQL AVG Function
Example
Return the average value for the “Price” column in the “Products” table:
SELECT AVG(Price) AS AveragePrice FROM Products;
Definition and Usage
The AVG() function returns the average value of an expression.
Note: NULL values are ignored.
Syntax
AVG(expression)