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

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

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

This article is written by plus2net.com team. https://www.plus2net.com

plus2net.com