Skip to main content

​
Overview

The SQRT() function returns the square root of a given positive number.

​
Syntax

The syntax for the SQRT() function in Oxla is: 
SQRT(x)
The SQRT() function requires one argument:
  • x: A positive number or an expression that evaluates to a positive number.

​
Examples

​
Case #1: SQRT() a Positive Value

The following example demonstrates how the SQRT() function can be used to find the square root of a positive integer: 
SELECT SQRT(81);
You will get the following result: 
+-----+
| f   |
+-----+
| 9   |
+-----+

​
Case #2: SQRT() With an Expression

Let’s look at an example of using the SQRT() function to find the square root of the result of an expression. 
SELECT SQRT(60 + 4);
The result of the above statement is the square root of 64: 
+-----+
| f   |
+-----+
| 8   |
+-----+

​
Case #3: SQRT() With Double Precision Result

In addition to integers, Oxla also supports calculating square roots with floating-point numbers as the outcome. For further details, please refer to the statement below: 
SELECT SQRT(70);
The output of the statement above is 8.3666, which is the square root of 70 with double precision, as demonstrated below: 
+----------+
| f        |
+----------+
| 8.3666   |
+----------+

​
Case #4: SQRT() a Negative Number

The following example demonstrates how attempting to use the SQRT() function with a negative value will return an error: 
SELECT SQRT(-25);
As the SQRT() function only accepts positive numbers, you will get a NaN (Not a Number) result for the square root of -25, as shown below: 
+-------+
| f     |
+-------+
| NaN   |
+-------+

​
Case #5: SQRT Operator (|/(x))

Here’s an example using the SQRT operator (|/(x)) to calculate the square root of a given number: 
SELECT |/(169) AS sqrt_operator;
In this example, we calculate the square root of 169 using the SQRT operator. The result of this query will be: 
 sqrt_operator 
---------------
            13