EXP()

EXP() is a mathematical function in SQL that returns the value of e raised to the power of a given number. Where e is a mathematical constant equal to approximately 2.71828, which is the base used in the determination of natural logarithms.

Syntax

EXP(number)

number represents a numeric value that e is raised to.

Example

The following table exp contains example data:

The EXP() function is used to return the value of e raised to the power of the num column:

SELECT id, num, EXP(num) as exp_num
FROM exp;

Output:

Note: The EXP() function can be used with many popular SQL databases such as SQLite, MySQL, PostgreSQL, and SQL Server.