SQL Tutorial

SQL EXP Function

The SQL EXP() function returns e raised to the n-th power (e is the base of the natural logarithm and is equal to approximately 2.718281828459). Here is the syntax:

EXP(<numeric_expression>)

Here is an example query of SQL EXP() function:

SELECT EXP(1) AS exponent_1,
	   EXP(10) AS exponent_10

And we get the output:

 
    exponent_1    exponent_10  
--------------  ---------------
2.718281828459  22026.465794807
Read On