POWER Function

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

Category:	Mathematical
Returned data type:	DOUBLE

Syntax

Required Arguments

Details

Example

Syntax

POWER(numeric-expression, power-numeric-expression)

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>
See	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