SQRT Function [Numeric]

Returns the square root of a number.

Syntax

SQRT ( numeric-expression )

Parameters

Parameter

Description

numeric-expression

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

Returns

DOUBLE

Standards and Compatibility

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

  • Sybase—Compatible with Adaptive Server Enterprise.

Example

The following statement returns the value 3:

SELECT SQRT( 9 ) FROM iq_dummy
Parent topic: Numeric Functions