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