Math and Numeric function in SQL Server

These all are the math function in SQL which helps users to manipulate on the number.

Math and Numeric function in SQL Server

SQL server absolute value function:-

ABS() function in SQL is used to get the absolute value of a number.

 Syntax : -

ABS(number)

  ACOS() SQL function:-

ACOS() function gives the arc cosine of a number.

 Syntax : -

ACOS(number)

ASIN() SQL function:-

ASIN() in SQL gives the arc sine of a number.

 Syntax : -

ASIN(number)

ATAN() SQL function:-

ATAN() method in SQL gives the arctangent of a number.

 Syntax : -

ATAN(number)

ATAN() SQL function:-

ATAN2() gives an arc tangent of two numbers in SQL.

 Syntax : -

ATN2(a, b)

AVG() SQL:-

AVG() function in SQL tell you about the average value of an expression.

Syntax : -

AVG(expression)

SQL CEILING() method:-

CEILING() method in SQL helps you to give the smallest integer value that is larger than or equal to a number. 

Syntax : -

CEILING(number)

SQL COUNT():-

COUNT() in SQL tells you about the number of records returned by a select query in Database. 

Syntax : -

COUNT(expression)

SQL COT():-

COT() function in SQL returns the cotangent of a number. 

Syntax : -

COT(number)

SQL DEGREES() function:-

SQL DEGREES() use to convert the radians value to degrees.

Syntax : -

DEGREES(number)

EXP() function:-

EXP() method in SQL raise the power of e to the specified number.

Syntax : -

EXP(number)

FLOOR() in SQL:-

FLOOR() function in SQL gives the largest integer value that is smaller than or equal to a number.


Syntax : -

FLOOR(number)

LOG() SQL:-

LOG() in SQL gives the logarithm value of any specified number or the logarithm of any number to the specified base.


Syntax : -

LOG(number, base) -- Syntax for SQL Server

LOG10() SQL:-

LOG10() gives the logarithm value with the base 10 of any specified value


Syntax : -

LOG10(number)

MAX() in SQL:-

MAX() function in SQL find the maximum number from a set of values.

Syntax : -

MAX(expression)

MIN() in SQL:-

MIN() function in SQL find the minimum number from a set of values.

Syntax : -

MIN(expression)

PI() in SQL:-

As its name says PI() function in SQL gives the value of PI.


Syntax : -

PI()

POWER() in SQL:-

POWER() in SQL server function gives the value which is raised to the power of any specified number.


Syntax : -

POWER(a, b)

RADIANS() in SQL:-

RADIANS() function used to convert the degree value into radians.

Syntax : -

RADIANS(number)

RAND() in SQL:-

RAND() function in SQL gives the random number between 0 (inclusive) and 1 (exclusive) if seed is specified then it would return the repeatable sequence of random numbers.


Syntax : -

RAND(seed)

ROUND() in SQL:-

ROUND() function in SQL gives the round number to a specified number of decimal places.

Syntax : -

ROUND(number, decimals, operation)

SQRT() method in SQL:-

SQRT() function in SQL gives the square root of a number.

Syntax : -

SQRT(number)

SQUARE() method in SQL:-

SQUARE() SQL function gives the square of a number. 

Syntax : -

SQUARE(number)

SUM() function in SQL:-

SUM() SQL function calculates the sum of a set of values.

Syntax : -

SUM(expression)

SUM() function in SQL:-

SUM() SQL function calculates the sum of a set of values.

Syntax : -

SUM(expression)

Read More