Mathematical functions are present in SQL server which can be used to perform mathematical calculations. Some commonly used mathematical functions are given below:

**1. SQRT(): **

SQRT() function is the most commonly used function. It takes any numeric values and returns the square root value of that number.

**Syntax:**

SELECT SQRT(..value..)

**Example:**

**2. PI():** There are calculations which require use of pi. Using pi() function, value of PI can be used anywhere in the query.

**Syntax:**

SELECT PI()

Example:

**3. SQUARE():** SQUARE() function is used to find the square of any number.

**Syntax:**

SELECT SQUARE(..value..)

**Example:**

**4. ROUND():** ROUND() function is used to round a value to the nearest specified decimal place.

**Syntax: **

SELECT ROUND(..value.., number_of_decimal_places)

**Example:**

**5. CEILING() and FLOOR()**

**CEILING():** CEILING() function is used to find the next highest value (integer).

**Syntax: **

SELECT CEILING(..value..)

**FLOOR():** FLOOR() function returns the next lowest value (integer).

**Syntax: **

SELECT FLOOR(..value..)

**Example:**

## leave a comment

## 0 Comments