Example
Return 4 raised to the second power:
SELECT POWER(4, 2);
Definition and Usage
The POWER() function returns the value of a number raised to the power of another number.
Syntax
POWER(a, b)
Parameter Values
| Parameter | Description |
|---|---|
| a | Required. A number (the base) |
| b | Required. A number (the exponent) |
Technical Details
| Works in: | SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse |
|---|
More Examples
Example
Return 8 raised to the third power:
SELECT POWER(8, 3);