login

SQL SQRT Function

The SQL SQRT function extracts the square root from the positive numeric input argument. SQL SQRT function accepts only positive arguments, and returns an error when a negative argument is passed in. Here is the syntax:

	SQRT(<numeric_expression>)

Here is a query example:

	SELECT SQRT(100) AS sqrt_of_100

And the output is

sqrt_of_100
-----------
         10
Read On