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

SELECT EXP( 2 ); // Output is 7.38905609893065
SELECT EXP(-2); // Output is 0.135335283236613
SELECT EXP(0); // Output is 1

EXP() with ROUND()

SELECT ROUND(EXP(-3),2);  // Output is 0.05

Syntax

SELECT EXP( X )

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

SELECT EXP( 1 ); // Output is 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

Subhendu Mohapatra

Author

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

Subscribe to our YouTube Channel here

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

EXP() with ROUND()

Subhendu Mohapatra