# Exponential and Root Functions

#### <mark style="color:purple;">POWER(</mark>  \<expr1>,   \<expr2>  <mark style="color:purple;">)</mark> &#x20;

Returns the value of  `expr1` raised to the power of `expr2.`

```sql
> select power(3.15, 0.5);
1.775
```

#### <mark style="color:purple;">FACTORIAL(</mark>  \<expr><mark style="color:purple;">)</mark> &#x20;

Computes the factorial of its input

Supported  datatype: Integer

```sql
> select factorial(5);
120
```

**NOTE** - The input must be an integer expression within the inclusive range of 0 to 20.

#### <mark style="color:purple;">CBRT(</mark>  \<expr>  <mark style="color:purple;">)</mark> &#x20;

Calculates the cubic root of a numerical value.

Support datatype: Integer, Double

```sql
> select cbrt(125);
5
> select cbrt(5);
1.709975946676697
```

#### <mark style="color:purple;">SQRT(</mark>  \<expr>  <mark style="color:purple;">)</mark> &#x20;

Calculates the square root of a numerical value.

Support datatype: Integer, Double

```sql
> select sqrt(4);
2
> select sqrt(-1);
nan
```

#### <mark style="color:purple;">EXP(</mark>  \<expr>  <mark style="color:purple;">)</mark> &#x20;

Calculates the exponential function of a floating-point value, with Euler's number e as the base

Support datatype: Integer, Double

```sql
> select exp(1);
2.7182818284590455
```