# POW

Returns the given number exponentiated to the given power.

## Syntax

```sql
POW ( number, power )
POWER ( number, power )

```

## Arguments

* expression: any valid numeric expression.
* power: any valid numeric expression.

## Return Type

Float or double. If either argument is null, returns `NULL`.

## Examples

```sql
SELECT POW(2, 8);

```

```output

+-----------+
| POW(2, 8) |
+-----------+
|       256 |
+-----------+

```

```sql
SELECT POW(2, 16);

```

```output

+------------+
| POW(2, 16) |
+------------+
|      65536 |
+------------+
```

```sql
SELECT POW(2, 24);

```

```output

+------------+
| POW(2, 24) |
+------------+
|   16777216 |
+------------+
```

```sql
SELECT POW(2, 2.5);

```

```output

+-------------------+
| POW(2, 2.5)       |
+-------------------+
| 5.656854249492381 |
+-------------------+
```

***

Modified at: February 24, 2023

Source: [/db/v9.1/reference/sql-reference/numeric-functions/pow/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/numeric-functions/pow/)

(An index of the documentation is available at /llms.txt)