The **SQL POWER function** is a built-in mathematical function in SQL that returns the value of a number raised to a specified power. The function takes two arguments: the base number and the exponent, and returns the result of the base number raised to the exponent.

## Syntax

The syntax for using the **POWER** function in SQL is as follows:

POWER(base, exponent)

Here, base is the base number and exponent is the exponent to which the base number is raised. Both base and exponent can be numeric values, numeric columns, or expressions that evaluate to numeric values.

### Example

For example, the following SQL query uses the **POWER** function to calculate the square of the values in the price column of a table named products:

SELECT product_name, POWER(price, 2) AS price_squared FROM products;

This query returns a result set that includes the product_name and price_squared columns. The price_squared column contains the square of the values in the price column.

It’s worth noting that the POWER function is equivalent to the ^ operator in most SQL implementations. That is, POWER(x, y) is the same as x ^ y. However, some databases may use a different operator for exponentiation, so it’s always a good idea to check the documentation for your specific database.

In summary, the **SQL POWER function** is a useful tool for performing mathematical calculations in SQL, particularly when raising a number to a power.