Related Articles

# SQL Server Mathematical functions (SQRT, PI, SQUARE, ROUND, CEILING & FLOOR)

• Difficulty Level : Basic
• Last Updated : 21 Mar, 2018

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: Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

My Personal Notes arrow_drop_up