SQRT

 

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


100% pure Java DBMS
Mirror Site