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

This article is written by plus2net.com team.

plus2net.com

▼ 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

✖

We use cookies to improve your browsing experience. . Learn more

HTML

MySQL

PHP

JavaScript

ASP

Photoshop

Articles

FORUM . Contact us