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 |