# SQUARE() Function in SQL Server

• Last Updated : 28 Dec, 2020

SQUARE() function :
This function in SQL Server is used to return the square of a specified number. For example, if the specified number is 9, this function will return 81 as output.

Features :

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

• This function is used to square a given number.
• This function accepts both that is positive and negative numbers.
• This function also accepts fraction numbers.
• This function always returns positive number.
• This function use the formula “(a)2 = Returned value”, where a is the specified number.

Syntax :

`SQUARE(number)`

Parameter :
This method accepts a parameter as given below as follows.

• number –
Specified number whose square is going to be returned.

Returns :
It returns the square of a specified number.

Example-1 :
Getting the result 16.0 which is the square of the specified number 4.

`SELECT SQUARE(4);`

Output :

`16.0`

Example-2 :
Getting the result 4.0 which is the square of the specified negative number -2.

`SELECT SQUARE(-2);`

Output :

`4.0`

Example-3 :
Getting the result 0.0 which is the square of the specified number zero (0).

`SELECT SQUARE(0);`

Output :

`0.0`

Example-4 :
Getting the result 1.0 which is the square of the specified number 1.

`SELECT SQUARE(1);`

Output :

`1.0`

Example-5 :
Getting the result 1.4399999999999999 which is the square of the specified number 1.2.

`SELECT SQUARE(1.2);`

Output :

`1.4399999999999999`

Application :
This function is used to return the square of a specified number.

My Personal Notes arrow_drop_up