Showing posts with label SQL math Function. Show all posts
Showing posts with label SQL math Function. Show all posts

## 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)`

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)`