MS SQL Server numeric capacities can be applied on numeric information and will restore numeric information.

Following is the rundown of Numeric capacities with models.

**ABS()**

Supreme worth will come as yield for numeric articulation.

**Example**

The accompanying question will give the outright worth.

`Select ABS(-22) `

**ACOS()**

Circular segment cosine worth will come as yield for the predetermined numeric articulation.

**Example**

The accompanying question will give the bend cosine estimation of 0.

`Select ACOS(0) `

**ASIN()**

Circular segment sine worth will come as yield for the predetermined numeric articulation.

**Example**

The accompanying question will give the curve sine estimation of 0.

`Select ASIN(0)`

**ATAN()**

Bend digression worth will come as yield for the predefined numeric articulation.

**Example**

The accompanying inquiry will give the bend digression estimation of 0.

`Select ATAN(0) `

**ATN2()**

Bend digression esteem in every one of the four quadrants will come as yield for the predefined numeric articulation.

**Example**

The accompanying question will give the circular segment digression esteem in every one of the four quadrants of 0.

`Select ATN2(0, -1) `

Consider the CUSTOMERS table having the accompanying 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()**

On the off chance that the qualities exist between given two articulations, at that point those will be come as yield.

**Example**

The accompanying question will give the accompanying yield.

`SELECT salary from customers where salary between 2000 and 8500`

Yield

```
salary
2000.00
2000.00
6500.00
8500.00
4500.00
```

**MIN()**

Least worth will come as yield from the given articulation.

`Example`

The accompanying question will give '1500.00' for the given 'compensation' articulation from the clients table.

`Select MIN(salary)from CUSTOMERS`

**MAX()**

Greatest worth will come as yield from the given articulation.

**Example**

The accompanying question will give '10000.00' for the given 'compensation' articulation from the clients table.

`Select MAX(salary)from CUSTOMERS`

**SQRT()**

Square foundation of the given numeric articulation will come as yield.

**Example**

The accompanying question will give 2 for the given 4 numeric articulation.

`Select SQRT(4) `

**PI()**

PI worth will come as yield.

**Example**

The accompanying question will give 3.14159265358979 for the PI esteem.

`Select PI() `

**CEILING()**

Given worth will come as yield in the wake of adjusting the decimals which is the following most elevated worth.

**Example**

The accompanying question will give 124 for the given 123.25 worth.

`Select CEILING(123.25) `

**FLOOR()**

Given worth will come as yield subsequent to adjusting the decimals which is not exactly or equivalent to the articulation.

**Example**

The accompanying question will give 123 for the given 123.25 worth.

`Select FLOOR(123.25) `

**LOG()**

Normal logarithm of the given articulation will come as yield.

**Example**

The accompanying question will give 0 for the given 1 worth.

`Select LOG(1) `