The function SQRT returns the square root value for the numeric expression.
This is equals to a power of 0.5.
SQL Syntax:
|
|
SQRT( number ) |
Number:
|
|
Any numeric expression. |
Escape Syntax:
|
|
{fn SQRT( number )} |
Return Type:
|
|
FLOAT |
|
|
|
Examples:
SELECT SQRT(4.0), {fn sqrt(9.0)} Returns: 2.0,
3.0
see also:
SQL Numeric Functions
POWER
EXP
|