sqrt
This function is used to return the square root of a value.
Syntax
sqrt(DOUBLE a)
Parameters
Parameter |
Mandatory |
Type |
Description |
---|---|---|---|
a |
Yes |
DOUBLE, BIGINT, DECIMAL, or STRING |
The value can be a float, integer, or string. If the value is not of the DOUBLE type, the system will implicitly convert it to the DOUBLE type for calculation. |
Return Values
The return value is of the DOUBLE type.
If the value of a is NULL, NULL is returned.
Example Code
The value 2.8284271247461903 is returned.
select sqrt(8);
The value 4 is returned.
select sqrt(16);
The value NULL is returned.
select sqrt(null);
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot