---
schema_version: "1"
id: 067652e84d8828c48ffc1e6b6b72974d55e26e65d1c77acd9d654907926cbeee
title: power({m},{n})
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_sql/guides/bi-sql-math-power.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-math-power.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 104a55dde2415e15c67cd68f89510132e9253c03e778c0bc16ba07b76a657288
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# power({m},{n})

Returns _m_ raised to the _n_th power. \_m_, _n_ can be any numeric value in the range of -1.797e308 \<= _m_, _n_ \<= 1.797e308. Returns null if _m_ = 0 and _n_ \< 0.

- If _m_ = 0, _n_ must be a non-negative value.
- If _m_ \< 0, _n_ must be an integer value.
- The result of power(_m_, _n_) must be within the range expressed by a float64 number.

`power({m},{n})` takes the following syntax.

```nolang
SELECT power(M,N) as AliasName
FROM dataset;
```

## Example

This example returns 2 raised to the 5th power.

```nolang
SELECT power(2, 5) as powerExample FROM Superstore
LIMIT 1;
```

| powerExampe |
| ----------- |
| 32.0        |