Articles Cookbook
Back to list
MySQL

How to Calculate a Square Root in SQL

Database:

Operators:

SQRT

Problem:

You want to find the square root of a number.

Example:

You want to compute the square root of all numbers in the column number from the table data.

number
9
2
1
0.25
0
-4

Solution 1:

SELECT
  number,
  SQRT(number) AS square_root
FROM data;

The result is:

numbersquare_root
93
21.4142135623731
11
0.250.5
00
-4error

Discussion:

To compute the square root of a number, use the SQRT() function. This function takes a number as its argument and returns the square root.

Note that there is no real square root from a negative number (imaginary numbers aren't supported) – hence the error.

Also, for most numbers (e.g., 2, 2.5, 3, 3.2 etc.) the square root is an irrational number – in the square_root column you won't see the exact results, only the first several digits of their decimal expansion.

Also, for most numbers (e.g., 2, 2.5, 3, 3.2 etc.) the square root is an irrational number – in the square_root column you won't see the exact results, only the first several digits of their decimal expansion.

Recommended courses:

Recommended articles:

See also:

go to top