SQL - Numeric Functions


SQL numeric functions are used primarily for numeric manipulation and/or mathematical calculations. The following table details the 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.

Advertisements