SQL - POWER() Function

---

SQL POWER() is the mathematical function that returns the value of a number raised to the power of another number. We need to pass the two numbers in the power function, where one number acts as the base and the other number acts as the exponent.

Syntax

Following is the syntax of the power() function −

SELECT POWER(X, Y) AS alias_name ;

Power function() accepts two number as a parameter −

• X − It is the first number that should be in base.

• Y − It is the second number that should be exponentiated.

Following is the syntax to use for the SQL; we can also apply the power function to the integer column of the table.

SELECT POWER(column1, column2) AS alias_name FROM table_name;

In the above SQL query, we can pass the column name from the table in which we want to perform the power() function.

Example

In the following example, we calculating the 5 raised to the power 3 in the SQL using the POWER() function.

Following is the SQL query where we are using the power function −

SELECT POWER(5, 3) AS cube_of_5;

Output

Following is the output of the above query −

+-----------+
| cube_of_5 |
+-----------+
|       125 |
+-----------+

Example

In the following example, we are calculating the 5 raised to the power 0 in the SQL using the POWER() function

Following is the query −

SELECT POWER(5, 0) AS 5_TO_THEPOWER_0;

Output

Following is the output of the above query, which gives 1 as a result. Any number raised to the power of 0 always returns 1.

+-----------------+
| 5_TO_THEPOWER_0 |
+-----------------+
|               1 |
+-----------------+

Example

In the following example, we are passing first value positive and second value as negative into the POWER() function.

Following is the query −

SELECT POWER(5, -2) AS negative_power_of_5;

Output

Following is the output of the above query, if a value is positive but its power is negative, the result is always 0 in SQL.

+---------------------+
| negative_power_of_5 |
+---------------------+
|                   0 |
+---------------------+

Example

In the following example, we are using emp_tbl to calculate the power of ID using the POWER() function and fetching the name from emp_tbl.

Let’s create a table named emp_tbl using the CREATE statement −

CREATE TABLE emp_tbl(ID INT NOT NULL, 
NAME VARCHAR(20), 
ACCOUNT_BL DECIMAL(10, 0), 
SALARY DECIMAL(18, 5));

Let’s insert the datas into the emp_tbl using the INSERT statement −

INSERT INTO emp_tbl VALUES(1, 'Raja', 1200, 1234.23450);
INSERT INTO emp_tbl VALUES(2, 'Vivek', 1500, 225.45600);
INSERT INTO emp_tbl VALUES(3, 'Roja', -1500, 3025.57600);
INSERT INTO emp_tbl VALUES(4, 'Lukha', -1700, 5065.16800);
INSERT INTO emp_tbl VALUES(5, 'Sonal', 1800, 10065.25400);

Let’s display the emp_tbl details using the SELECT statement −

SELECT * FROM emp_tbl

Following is the emp_tbl −

+----+-------+------------+-------------+
| ID | NAME  | ACCOUNT_BL | SALARY      |
+----+-------+------------+-------------+
|  1 | Raja  |       1200 |  1234.23450 |
|  2 | Vivek |       1500 |   225.45600 |
|  3 | Roja  |      -1500 |  3025.57600 |
|  4 | Lukha |      -1700 |  5065.16800 |
|  5 | Sonal |       1800 | 10065.25400 |
+----+-------+------------+-------------+

Following is the SQL query −

SELECT POWER(ID, 2) AS power_of_Id, NAME FROM emp_tbl;

Output

Following is the output of the above query, which shows the name and power of the ID −

+-------------+-------+
| power_of_Id | NAME  |
+-------------+-------+
|           1 | Raja  |
|           4 | Vivek |
|           9 | Roja  |
|          16 | Lukha |
|          25 | Sonal |
+-------------+-------+