POWER() Function in MySQL
POWER() function in MySQL is used to find the value of a number raised to the power of another number. It Returns the value of X raised to the power of Y.
Syntax :
POWER(X, Y)
Parameter : This method accepts two parameter which are described below :
- X : It specifies the base number.
- Y : It specifies the exponent number.
Returns : It returns the value of X raised to the power of Y.
Example-1 : Finding Power value when both base and exponent is positive using POWER() function.
SELECT POWER( 5, 4) AS Power_Value ;
Output :
Power_Value |
---|
625 |
Example-2 : Finding Power value when base and is positive but exponent is negative using POWER() function.
SELECT POWER( 2, -4) AS Power_Value ;
Output :
Power_Value |
---|
0.0625 |
Example-3 : Finding Power value when base and is negative but exponent is positive using POWER() function.
SELECT POWER( -3, 3) AS Power_Value ;
Output :
Power_Value |
---|
-27 |
Example-4 : Finding Power value when both base and exponent is negative using POWER() function.
SELECT POWER( -3, -4) AS Power_Value ;
Output :
Power_Value |
---|
0.012345679012345678 |
Example-5 : The POWER function can also be used to find the power value between column data. To demonstrate create a table named.
Triangle.
CREATE TABLE Triangle( Type VARCHAR(25) NOT NULL, NoOfSides INT NOT NULL, Base INT NOT NULL, Height INT NOT NULL );
Now inserting some data to the Triangle table :
INSERT INTO Triangle(Type, NoOfSides, Base, Height ) VALUES ('Right-angled Triangle', 3, 4, 3 ), ('Right-angled Triangle', 3, 2, 5 ), ('Right-angled Triangle', 3, 1, 7 ), ('Right-angled Triangle', 3, 7, 9 ), ('Right-angled Triangle', 3, 4, 6 ), ('Right-angled Triangle', 3, 8, 3 ), ('Right-angled Triangle', 3, 10, 10 ) ;
Showing all data in Triangle Table –
Select * from Triangle ;
Type | NoOfSides | Base | Height |
---|---|---|---|
Right-angled Triangle | 3 | 4 | 3 |
Right-angled Triangle | 3 | 2 | 5 |
Right-angled Triangle | 3 | 1 | 7 |
Right-angled Triangle | 3 | 7 | 9 |
Right-angled Triangle | 3 | 4 | 6 |
Right-angled Triangle | 3 | 8 | 3 |
Right-angled Triangle | 3 | 10 | 10 |
Now, we are going to find the hypotenuse and area for each Right-angled Triangle.
SELECT *, sqrt(POWER(Base, 2) + POWER(Height, 2)) AS Hypotenuse, 0.5 * Base * Height as Area FROM Triangle;
Output :
Type | NoOfSides | Base | Height | Hypotenuse | Area |
---|---|---|---|---|---|
Right-angled Triangle | 3 | 4 | 3 | 5 | 6.0 |
Right-angled Triangle | 3 | 2 | 5 | 5.385164807134504 | 5.0 |
Right-angled Triangle | 3 | 1 | 7 | 7.0710678118654755 | 3.5 |
Right-angled Triangle | 3 | 7 | 9 | 11.40175425099138 | 31.5 |
Right-angled Triangle | 3 | 4 | 6 | 7.211102550927978 | 12.0 |
Right-angled Triangle | 3 | 8 | 3 | 8.54400374531753 | 12.0 |
Right-angled Triangle | 3 | 10 | 10 | 14.142135623730951 | 50.0 |
Contact Us