POWER Function in SQL

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

Syntax:

POWER(base, exponent)

• base: The number to be raised.

• exponent: The power to which the base is raised.

Example:

Calculate 3 raised to the power 4:

SELECT POWER(3, 4) AS result;

Result:

Notes:

• Supported in most SQL databases: MySQL, PostgreSQL, SQL Server, Oracle.

• Equivalent to POW() in many databases.

• Works with integers, decimals, and negative/fractional exponents.

If you want, I can provide more examples or explain differences between POWER and other math functions!