Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

SQRT Function

The SQRT function returns the square root of a numeric value.

Syntax

Copy
SQRT (expression)

Argument

expression

The expression must have an integer, decimal, or floating-point data type.

Return Type

SQRT returns a DOUBLE PRECISION number.

Examples

The following example returns the square root for some COMMISSION values from the SALES table. The COMMISSION column is a DECIMAL column.

Copy
select sqrt(commission) from sales where salesid <10 order by salesid; sqrt ------------------ 10.4498803820905 3.37638860322683 7.24568837309472 5.1234753829798 ...

The following query returns the rounded square root for the same set of COMMISSION values.

Copy
select salesid, commission, round(sqrt(commission)) from sales where salesid <10 order by salesid; salesid | commission | round --------+------------+------- 1 | 109.20 | 10 2 | 11.40 | 3 3 | 52.50 | 7 4 | 26.25 | 5 ...