POW Function in SQL

The POW() function returns the value of a number raised to the power of another number.

Syntax:

POW(base, exponent)

• base — the number to be raised.

• exponent — the power to which the base is raised.

Example:

Calculate 2 raised to the power 3:

SELECT POW(2, 3) AS result;

Result:

Notes:

• POW() is supported in MySQL, PostgreSQL, SQL Server (as POWER()), Oracle (as POWER()).

• In SQL Server and Oracle, use POWER() instead of POW().

Equivalent in SQL Server:

SELECT POWER(2, 3) AS result;

Want examples with negative powers or fractional powers?