POWER()

Scalar. Returns the value of a given base raised to a specified exponent.

Syntax

POWER( base, exponent )
Data Types

Return

base

exponent

Float

Integer

Float

Long

Float

Example

The following example returns the value of the velocity column to the fourth power:

INSERT INTO OutStream
SELECT POWER(Devices.velocity,4.0)
FROM Devices;