EXP() Function in MySQL
Last Updated :
30 Oct, 2020
EXP() function in MySQL is used to returns E raised to the power of a specified number. Here E(2.718281…) is the base of the natural logarithm.
Syntax :
EXP(X)
Parameter : This method accepts one parameter as mentioned above in the syntax and described below :
X – A specified number which will be used as a power of E.
Returns : It returns E raised to the power of the given number X.
Example-1 :
Calculating e raised to the power of 1 using EXP() function.
SELECT EXP(1) AS Exp_Val ;
Output :
EXP_VAL |
2.718281828459045 |
Example-2 :
Calculating e raised to the power of -3 using EXP() function.
SELECT EXP(-3) AS Exp_Val ;
Output :
EXP_VAL |
0.049787068367863944 |
Example-3 :
The EXP function can also be used in a column data. To demonstrate create a table named Product.
CREATE TABLE Product(
Product_id INT AUTO_INCREMENT,
Product_name VARCHAR(100) NOT NULL,
Buying_price DECIMAL(13, 2) NOT NULL,
Selling_price DECIMAL(13, 2) NOT NULL,
Service_grade Decimal(6, 2) NOT NULL,
PRIMARY KEY(Product_id)
);
Now inserting some data to the Product table –
INSERT INTO
Product(Product_name, Buying_price, Selling_price, Service_grade)
VALUES
('ASUS ROG', 80000.00, 100000.00, 4.00 ),
('DELL INSPIRON', 75000.00, 90000.00, 3.00 ),
('ACER PREDATOR', 100000.00, 134000.00, 2.50 ),
('LENOVO LEGION', 90000.00, 118000.00, 1.50 ),
('HP OMEN', 70000.00, 85000.00, 5.00) ;
Showing all data in Product Table –
Select * from Product;
PRODUCT_ID |
PRODUCT_NAME |
BUYING_PRICE |
SELLING_PRICE |
SERVICE_GRADE |
1 |
ASUS ROG |
80000.00 |
100000.00 |
4.00 |
2 |
DELL INSPIRON |
75000.00 |
90000.00 |
3.00 |
3 |
ACER PREDATOR |
100000.00 |
134000.00 |
2.50 |
4 |
LENOVO LEGION |
90000.00 |
118000.00 |
1.50 |
5 |
HP OMEN |
70000.00 |
85000.00 |
5.00 |
Now, we are going to find exp values for all the records present in the Service_grade column.
Select Product_id, Product_name, Buying_price,
Selling_price, Service_grade,
EXP(Service_grade) AS EXPGRADE
FROM Product;
Output :
PRODUCT_ID |
PRODUCT_NAME |
BUYING_PRICE |
SELLING_PRICE |
SERVICE_GRADE |
EXPGRADE |
1 |
ASUS ROG |
80000.00 |
100000.00 |
4.00 |
54.598150033144236 |
2 |
DELL INSPIRON |
75000.00 |
90000.00 |
3.00 |
20.085536923187668 |
3 |
ACER PREDATOR |
100000.00 |
134000.00 |
2.50 |
12.182493960703473 |
4 |
LENOVO LEGION |
90000.00 |
118000.00 |
1.50 |
4.4816890703380645 |
5 |
HP OMEN |
70000.00 |
85000.00 |
5.00 |
148.4131591025766 |
Share your thoughts in the comments
Please Login to comment...