POWER Function

Returns the value of a numeric value expression raised to a specified power.

Category: Mathematical
Returned data type: DOUBLE

Syntax

Required Arguments

numeric-expression

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

Data type BIGINT, DOUBLE, FLOAT, INTEGER, REAL, SMALLINT, TINYINT
See <sql-expression>
FedSQL Expressions

power-numeric-expression

specifies any valid SQL expression that evaluates to a numeric value. This argument is the power value.

Details

If numeric-expression is a null or missing value, then the POWER function returns a null or missing value. If the result is a number that does not fit into the range of a DOUBLE, the POWER function fails.

Example

Table: DENSITIES
The following statements illustrate the POWER function:
Statements
Results
select power(5*3, 2);
225
select name from densities
 where squaremiles >= power(density,2);
Afghanistan
Algeria
Angola
Argentina
Australia
Last updated: February 23, 2017