The **`POWER()` function** calculates the value of the #key# number: base #key# raised to the `power` of another #key# number: exponent #key#. 

Figure 1 shows the mathematical representation of the `POWER()` function.

# Syntax
```sql
POWER(baseNumber, exponent)
```
# Parameters
The `POWER()` function requires two parameters:

- A base number. 
- An exponent number.

# Return value
`POWER()` returns the value of the base number raised to the exponent number. 

# Example

/*example showing how to use POWER(X)*/

-- positive: baseNumber     positive: exponent
SELECT POWER(10, 2);

-- positive: baseNumber     negative: exponent
SELECT POWER(0.25, -2);

-- neagtive: baseNumber     positive: exponent
SELECT POWER(-10, 2);

-- neagtive: baseNumber     negative: exponent
select POWER(-0.5, -1);


What is POWER() in SQL?

Syntax

Parameters

Return value

Example