SQL Server POWER() Function

The SQL Server POWER() function is used to return a given expression raised to the specified power.

Syntax

The syntax for the POWER() function is as follows:

POWER(numeric_expression, y)

Here, numeric_expression is the number expression to be calculated, and y is the exponent.

Usage

The POWER() function is typically used to calculate the power of a number. For example, it can be used to calculate interest rates, compound annual growth rates, and so on.

Examples

Here are two examples of the POWER() function:

Example 1

Calculate the second power of a number expression:

SELECT POWER(2, 2) AS Result;

Result:

Result
4

Example 2

Use the POWER() function to calculate the interest on some compound interest:

SELECT 10000 * POWER(1 + 0.05, 5) AS Result;