sqrt(n)
Returns the square root of a number n. The value n
can be any non-negative numeric value in the range of 0 <= n <=
1.797e308.
sqrt(n) takes the following syntax.
SELECT sqrt(n) as AliasName
FROM dataset;
Example
This example returns the square root of 64.
SELECT sqrt(64.0) as SqrtExample FROM Superstore
LIMIT 1;
SqrtExample |
---|
8.0 |