> For the complete documentation index, see [llms.txt](https://docs.e6data.com/product-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.e6data.com/product-documentation/sql-command-reference/mathematical-functions-and-operators/exponential-and-root-functions.md).

# 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
```