Trusted answers to developer questions
Trusted Answers to Developer Questions

Related Tags

exp
sql
math
communitycreator

What is EXP() in SQL?

Harris Amjad

Grokking Modern System Design Interview for Engineers & Managers

Ace your System Design Interview and take your career to the next level. Learn to handle the design of applications like Netflix, Quora, Facebook, Uber, and many more in a 45-min interview. Learn the RESHADED framework for architecting web-scale applications by determining requirements, constraints, and assumptions before diving into a step-by-step design process.

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);

RELATED TAGS

exp
sql
math
communitycreator

Grokking Modern System Design Interview for Engineers & Managers

Ace your System Design Interview and take your career to the next level. Learn to handle the design of applications like Netflix, Quora, Facebook, Uber, and many more in a 45-min interview. Learn the RESHADED framework for architecting web-scale applications by determining requirements, constraints, and assumptions before diving into a step-by-step design process.

Keep Exploring