Navigation:  NexusDB Guide > SQL Reference > SQL Functions > Numeric Value Functions >

Square Root Function

 Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

Square Root Function

button_main button_prev button_next

NexusDB Manual V3 > SQL Reference > SQL Functions > Numeric Value Functions

Syntax

 

<square root> ::=

 

 

 

SQRT ( <numeric value expression> )

 

Notes

 

§

The SQRT function returns the square root of the argument.

 

§

The data type of the result is DOUBLE PRECISION.

 

§

If the argument is null, then the result is null.

 

 

Examples

 

 

Expression

 

 

Result

 

SQRT( 4 )

2

SQRT( 5 )

2.236068..

 

Conformance

 

SQL:2003 standard

-

Feature T621 "Enhanced numeric functions"

 

© Nexus Database Systems Pty Ltd.

nexus_logo