T-SQL - Numeric Functions


Advertisements


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) 


Advertisements
E-Books Store