EXP()

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.

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

Your Rating

▼ More on Math functions in SQL

SQL Popular Tutorials

Order by displaying records Records Between two date ranges Some of the records by LIMIT query SQL SUM of data in columns