What is EXP() in SQL?

The EXP() function returns the mathematical e raised to the power of a specific number. Here, e is the base of the natural logarithm. Figure 1 shows the mathematical representation of the EXP() function.

Figure 1: Mathematical representation of the EXP() function

Syntax

EXP(number)

Parameter

This function requires a number as a parameter.

Return value

EXP() returns the mathematical e raised to the power of the specific number sent as a parameter.

Example

/*example showing how to use EXP(number)*/
-- positive number
select EXP(10);
-- negative number
select EXP(-3);
-- zero number
select EXP(0);
New on Educative
Learn any Language for FREE all September 🎉
For the entire month of September, get unlimited access to our entire catalog of beginner coding resources.
🎁 G i v e a w a y
30 Days of Code
Complete Educative’s daily coding challenge every day in September, and win exciting Prizes.

Free Resources