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 
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
Subscribe to our YouTube Channel here


* indicates required
Subscribe to plus2net


    Post your comments , suggestion , error , requirements etc here

    SQL Video Tutorials

    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2024 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer