SQL numeric functions are used primarily for numeric manipulation and mathematical calculations. Below is a detailed list of important SQL numeric functions:
| Sr.No. | Function | Description |
|---|---|---|
| 1 | ABS() | Returns the absolute value of numeric expression. |
| 2 | ACOS() | Returns the arccosine of numeric expression. Returns NULL if the value is not in the range -1 to 1. |
| 3 | ASIN() | Returns the arcsine of numeric expression. Returns NULL if value is not in the range -1 to 1 |
| 4 | ATAN() | Returns the arctangent of numeric expression. |
| 5 | ATN2() | Returns the arctangent of the two variables passed to it. |
| 6 | CEILING() | Returns the smallest (closest to negative infinity) integer value that is greater than or equal to this value. |
| 7 | COS() | Returns the trigonometric cosine of the given value. |
| 8 | COT() | Returns the trigonometric cotangent of the given value. |
| 9 | DEGREES() | Returns numeric expression converted from radians to degrees. |
| 10 | EXP() | Returns the base of the natural logarithm (e) raised to the power of passed numeric expression. |
| 11 | FLOOR() | Returns the largest integer value that is not greater than passed numeric expression. |
| 12 | LOG() | Returns the natural logarithm of the passed numeric expression. |
| 13 | LOG10() | Returns the base-10 logarithm of the passed numeric expression. |
| 14 | PI() | Returns the value of pi |
| 15 | POWER() | Returns the value of one expression raised to the power of another expression |
| 16 | RADIANS() | Returns the value of passed expression converted from degrees to radians. |
| 17 | RAND() | Returns the random value between 0 and 1. |
| 18 | ROUND() | Returns numeric expression rounded to an integer. Can be used to round an expression to a number of decimal points |
| 19 | SIGN() | Returns the sign of a number, indicating whether it is positive, negative, or zero. |
| 20 | SIN() | Returns the sine of numeric expression given in radians. |
| 21 | SQRT() | Returns the non-negative square root of numeric expression. |
| 22 | TAN() | Returns the tangent of numeric expression expressed in radians. |