SQRT Function

Returns the square root of a value.

Category: Mathematical
Returned data type: DOUBLE
Syntax
Arguments
Example

Syntax

SQRT(expression)

Arguments

expression

specifies any SQL valid expression that evaluates to a nonnegative numeric value.

Data type DOUBLE
See <sql-expression>
FedSQL Expressions

Example

The following statements illustrate the SQRT function:
Statements
Results 
select sqrt(36);
 
6
 
select sqrt(25);
 
5
 
select sqrt(4.4);
 
2.097618
Copyright © SAS Institute Inc. All rights reserved.