SQL SQRT()

SQRT() is a function in SQL that returns the square root of a number input. The square root of any given number is a value that multiplied by itself will result in the passed number.

Syntax

SQRT(number);

Copy to clipboard
Copy to clipboard

number in this case should be any positive integer. For example, 144 as seen below.

Example

The square root of 144 is 12, as 12 multiplied by 12 equals 144. It is important to note, SQRT() requires a positive number, and will always return a positive number.

SELECT SQRT(144);

Copy to clipboard
Copy to clipboard

Yields:

12

Copy to clipboard
Copy to clipboard

Note: SQRT() is compatible with different SQL database platforms such as MySQL, PostgreSQL, Oracle, and SQL Server.