SQRT Function [Numeric]

Returns the square root of a number.

Syntax

SQRTnumeric-expression )

Parameters

Parameter

Description

numeric-expression

The number for which the square root is to be calculated.

Returns

DOUBLE

Example

The following statement returns the value 3:

SELECT SQRT( 9 ) FROM iq_dummy

Standards and Compatibility

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Compatible with Adaptive Server Enterprise.