SQL SQRT() Function


The SQL SQRT() is a function, and returns Double specifying the square root of a non-negative number.

The SQL SQRT() function is supports only numeric column or an numeric field based expression and required number argument is a Double or any valid numeric expression greater than or equal to zero.

It can be used in SELECT statement as well in where clause.


SQL SQRT() Syntax

For MySql / Microsoft SQL SERVER


// For Input Number or Expression Value

SELECT SQRT(valid_number);

// For Table Column

SELECT SQRT(Column_name) FROM table_name;

For Microsoft ACCESS


// For Input Number or Expression Value

SELECT SQR(valid_number);

// For Table Column

SELECT SQR(Column_name) FROM table_name;


SQL SQRT() Example - Using Expression Or Formula

The following SQL SELECT statement returns the absolute value of a given input number or expression


SELECT SQRT(4) AS 'Square Root Of 4';

The result of above query is:

Square Root Of 4
2

SQL SQRT() Function More Example

Input Value Result
SQRT(9) 3
SQRT(16) 4
SQRT(4.0) 2
SQRT(10) 3.16227766016838
SQRT(1.3) 1.1401754250991381
SQRT(5.675) 2.382225849914319

Sample Database Table - EmpInfo

ID EmpName Gender Age City
1 Vidyavathi Male 34 Ramnad
2 Harish Karthik Male 28 Mysore
3 Nirmala Female 32 Paramakudi
4 Varshini Kutty Male 26 Bangalore
5 Chandra Male 32 Pune
6 Balan Female 26 Madurai
7 Nirmala Female 33 Aruppukoottai
8 Dharan Male 25 Pune

SQL SQRT() Example - With Table Column

The following SQL SELECT statement find the square root of a given table column "ID" and "Age" from the "EmpInfo" table:

For MySql / Microsoft SQL Server


SELECT 
ID, SQRT(ID) AS 'Square Root Of ID',
Age, SQRT(Age) AS 'Square Root Of Age'
FROM EmpInfo;

For Microsoft ACCESS


SELECT 
ID, SQR(ID) AS 'Square Root Of ID',
Age, SQR(Age) AS 'Square Root Of Age'
FROM EmpInfo;

The result of above query is:

ID Square Root Of 'ID' Age Square Root Of 'Age'
1 1 34 5.8309518948453
2 1.4142135623731 28 5.29150262212918
3 1.73205080756888 32 5.65685424949238
4 2 26 5.09901951359278
5 2.23606797749979 32 5.65685424949238
6 2.44948974278318 26 5.09901951359278
7 2.64575131106459 33 5.74456264653803
8 2.82842712474619 25 5

SQL SQRT() Example - Using WHERE Clause

The following SQL SELECT statement find the square root value of a given input number for creating condition (less than or equal to the returned square root value) on table column "ID" from the "EmpInfo" table:


SELECT * FROM EmpInfo
WHERE ID <= SQRT(4);

The result of above query is:

ID EmpName Gender Age City
1 Vidyavathi Male 34 Ramnad
2 Harish Karthik Male 28 Mysore

Note: The SQRT(4) function will return a value of "2". So now the result set contains and display records or rows which has ID less than or equal to "2" on column "ID" from the "EmpInfo" table.