# T-SQL - Numeric Functions

MS SQL Server numeric functions can be applied on numeric data and will return numeric data.

Following is the list of Numeric functions with examples.

## ABS()

Absolute value will come as output for numeric expression.

### Example

The following query will give the absolute value.

Select ABS(-22)

## ACOS()

Arc cosine value will come as output for the specified numeric expression.

### Example

The following query will give the arc cosine value of 0.

Select ACOS(0)

## ASIN()

Arc sine value will come as output for the specified numeric expression.

### Example

The following query will give the arc sine value of 0.

Select ASIN(0)

## ATAN()

Arc tangent value will come as output for the specified numeric expression.

### Example

The following query will give the arc tangent value of 0.

Select ATAN(0)

## ATN2()

Arc tangent value in all four quadrants will come as output for the specified numeric expression.

### Example

The following query will give the arc tangent value in all four quadrants of 0.

Select ATN2(0, -1)

Consider the CUSTOMERS table having the following records.

ID NAME AGE ADDRESS SALARY 1 Ramesh 32 Ahmedabad 2000.00 2 Khilan 25 Delhi 1500.00 3 kaushik 23 Kota 2000.00 4 Chaitali 25 Mumbai 6500.00 5 Hardik 27 Bhopal 8500.00 6 Komal 22 MP 4500.00 7 Muffy 24 Indore 10000.00

## BETWEEN()

If the values exist between given two expressions then those will be come as output.

### Example

The following query will give the following output.

SELECT salary from customers where salary between 2000 and 8500

### Output

salary 2000.00 2000.00 6500.00 8500.00 4500.00

## MIN()

Minimum value will come as output from the given expression.

### Example

The following query will give '1500.00' for the given 'salary' expression from the customers table.

Select MIN(salary)from CUSTOMERS

## MAX()

Maximum value will come as output from the given expression.

### Example

The following query will give '10000.00' for the given 'salary' expression from the customers table.

Select MAX(salary)from CUSTOMERS

## SQRT()

Square root of the given numeric expression will come as output.

### Example

The following query will give 2 for the given 4 numeric expression.

Select SQRT(4)

## PI()

PI value will come as output.

### Example

The following query will give 3.14159265358979 for the PI value.

Select PI()

## CEILING()

Given value will come as output after rounding the decimals which is the next highest value.

### Example

The following query will give 124 for the given 123.25 value.

Select CEILING(123.25)

## FLOOR()

Given value will come as output after rounding the decimals which is less than or equal to the expression.

### Example

The following query will give 123 for the given 123.25 value.

Select FLOOR(123.25)

## LOG()

Natural logarithm of the given expression will come as output.

### Example

The following query will give 0 for the given 1 value.

Select LOG(1)