exp to get value of e raised to the power of argument using MySQL query

SELECT EXP(2);   -- 7.38905609893065
SELECT EXP(-2);  -- 0.135335283236613
SELECT EXP(0);   -- 1

EXP() with ROUND()

SELECT ROUND(EXP(-3), 2);  -- 0.05

Syntax

SELECT EXP(X);

We can get value of e raised to the power of X Example

SELECT EXP(1);  -- 2.71828182845905

The value of e ( the base of natural logarithms ) is almost equal to 2.71828182845905. So any argument passed to EXP() gives the output by raising the power of e to this value.
SQL Math References POW() ABS() to get Absolute value Average value Query

All Math Functions POW()

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

EXP(): value of e raised to the power of input number

EXP() with ROUND()

Subhendu Mohapatra