December 18th, 2008
POWER (raise no. to power)
Posted by
admin in
H. ANSI Numeric Scalar Functions
The POWER function raises a number to a specific power or exponent.
Format: POWER(base, exponent)
Example: POWER(10, 2) Result: 100
POWER(0, 0) Result: 1
POWER(10, -3) Result: .001
> DB2, Oracle, PostgreSQL, and SQL Server support the POWER function.
> Access uses ^ (an up arrow) to raise a number to a power or exponent.
> MySQL supports POW(base, exponent).
Comments Off
