POWER()

The POWER() function in SQL is a mathematical function that returns the value of a number raised to the power of another number. It is compatible with various SQL database systems such as MySQL, PostgreSQL, Oracle, and SQL Server.

Syntax

SELECT POWER(base, exponent)
FROM table_name;

Example

In this example the following data is given in the table numbers:

The POWER() function can be used to calculate the result:

SELECT base_number, exp_number, POWER(base_number, exp_number) AS power_number
FROM numbers;

The output will be: