​

Overview

The POWER() function calculates the value of a number raised to the power of another number specified in the arguments.

​

Syntax

The following illustrates the syntax of the POWER() function:

POWER(a,b)

Where:

• a: The base number.

• b: The exponent to which the base number is raised.

​

Examples

Let’s explore some examples of the POWER() function.

​

Case #1: Basic Usage

In this case, the POWER() function calculates the result of raising one number to the power of another.

SELECT POWER(3, 4) AS "Example 1",
       POWER(7, 3) AS "Example 2";

You will get the output below:

 Example 1 | Example 2 
-----------+-----------
        81 |       343

​

Case #2: Using POWER() with Negative Values

In this case, the POWER() function is applied to negative numbers.

SELECT POWER(-4, -5), POWER(-1, -2), POWER(-6, -7);

You will get the output below:

 power | power | power 
-------+-------+-------
 -1024 |     1 |     0

​

Case #3 Using POWER() with Floating-Point Numbers

In this example, the POWER() function is used to calculate 2.5 raised to the power of 3.0.

SELECT POWER(2.5, 3.0) AS power_result;

The result, 15.625, is the value obtained by raising 2.5 to the third power.

 power_result
--------------
       15.625

​

Case #4 Zero To the Power of Zero

This case shows that 0 expression raised to the power of 0 returns 1.

SELECT POWER(0, 0);

You will get the output below:

 power 
-------
     1