We can get value of e raised to the power of X
SELECT EXP( X )
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.
SELECT EXP( 1 ); // Output is 2.71828182845905
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
This article is written by plus2net.com team.
| ▼ More on Math functions in SQL|