# SQL EXP() Function: Complete Guide

SQL EXP function is a SQL Mathematical function that is used to return E raised to the power of the given float value, Where E is Euler’s number and it is approximately equal to 2.71828.

## SQL EXP()

SQL EXP() is a built-in function that is used for finding the exponent of a float_expression specified. The exponent of the number is the constant e raised to the power of the number. The base of natural logarithms is e (2.718281…), which is constant.

### Syntax

```SELECT EXP (float_expression);
```

### Parameters

Float_expression: An expression of float or any other type which is implicitly converted to float whose exponential value is to be retrieved.

See the following example.

```SELECT EXP(1);
```

#### Output

```2.71828182845905
```

### Explanation

Here, the exponential value is returned.

See the second example.

```SELECT EXP(2.5);
```

#### Output

```12.182493960703473
```

### Explanation

Here, the exponential value of a fractional number is returned.

### Example 3

`SELECT EXP (1+2);`

#### Output

```20.085536923187668
```

### Explanation

Here, the exponential value of the expression is returned.

### Example 4

```SELECT EXP (LOG (15)) 'EXP', LOG (EXP (15)) 'LOG';
```

#### Output

 EXP LOG 15 15

### Explanation

Here, we know that the LOG () function is an inverse of the EXP() function. So, the same value is returned.

## Conclusion

SQL EXP() function returns the e raised to the n-th power(n is the numeric expression), where e is a base of the natural algorithm and the value of e is approximately 2.71828183.

SQL format

SQL upper

SQL reverse

SQL space

SQL right

Categories SQL

This site uses Akismet to reduce spam. Learn how your comment data is processed.