Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Databricks SQL Databricks Runtime
Returns the square root of expr.
Syntax
sqrt(expr)
Arguments
expr: An expression that evaluates to a numeric.
Returns
For DECFLOAT inputs, the result is DECFLOAT with the same precision as expr. For other inputs, the result is a DOUBLE.
If expr is negative the result is NaN.
Examples
> SELECT sqrt(4);
2.0
> SELECT sqrt(-4);
NaN