Mathematical Functions in SQL Server
Table of Content:
Function | Description |
---|---|
ABS | Returns the absolute value of a number |
ACOS | Returns the arc cosine of a number |
ASIN | Returns the arc sine of a number |
ATAN | Returns the arc tangent of a number |
ATN2 | Returns the arc tangent of two numbers |
AVG | Returns the average value of an expression |
CEILING | Returns the smallest integer value that is >= a number |
COUNT | Returns the number of records returned by a select query |
COS | Returns the cosine of a number |
COT | Returns the cotangent of a number |
DEGREES | Converts a value in radians to degrees |
EXP | Returns e raised to the power of a specified number |
FLOOR | Returns the largest integer value that is <= to a number |
LOG | Returns the natural logarithm of a number, or the logarithm of a number to a specified base |
LOG10 | Returns the natural logarithm of a number to base 10 |
MAX | Returns the maximum value in a set of values |
MIN | Returns the minimum value in a set of values |
PI | Returns the value of PI |
POWER | Returns the value of a number raised to the power of another number |
RADIANS | Converts a degree value into radians |
RAND | Returns a random number |
ROUND | Rounds a number to a specified number of decimal places |
SIGN | Returns the sign of a number |
SIN | Returns the sine of a number |
SQRT | Returns the square root of a number |
SQUARE | Returns the square of a number |
SUM | Calculates the sum of a set of values |
TAN | Returns the tangent of a number |