Categories: Math

# POWER

Returns the result of raising the input value to the specified power.

## Syntax

### POWER(numeric_expression double, power double) → double

• numeric_expression: The input expression.
• power: The power to raise the numeric_expression to.

Examples

``````SELECT POWER(5, 2)
-- 25.0
``````
``````SELECT POWER(0.1, 2)
-- 0.010000000000000002
``````
``````SELECT POWER(-2, 2)
-- 4.0
``````
``````SELECT POWER(10, -2)
-- 0.01
``````

## Usage Notes

This function always returns a double even if the parameters are both integers.
{"ft_lang_label":"__label__en","ft_lang_prob":0.5283998,"math_prob":0.9732556,"size":601,"snap":"2022-05-2022-21","text_gpt3_token_len":163,"char_repetition_ratio":0.1524288,"word_repetition_ratio":0.022222223,"special_character_ratio":0.29617304,"punctuation_ratio":0.18487395,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.98267144,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2022-05-25T06:24:12Z\",\"WARC-Record-ID\":\"<urn:uuid:988f53a7-9f2e-49ac-8456-47b1b1ab5ce1>\",\"Content-Length\":\"56590\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:844386c9-3ac5-447f-bf84-9226d7a33859>\",\"WARC-Concurrent-To\":\"<urn:uuid:1e997363-1f14-413a-b2ed-53ff4654f05d>\",\"WARC-IP-Address\":\"52.73.87.228\",\"WARC-Target-URI\":\"https://docs.dremio.com/cloud/sql/sql-functions/functions/power/\",\"WARC-Payload-Digest\":\"sha1:LZZW5WISR7CPXMEZZ53RNBHCQCYWQXIG\",\"WARC-Block-Digest\":\"sha1:7T2FYOAFV2NQ7E3HC7AMEWWATA4266SB\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2022/CC-MAIN-2022-21/CC-MAIN-2022-21_segments_1652662580803.75_warc_CC-MAIN-20220525054507-20220525084507-00585.warc.gz\"}"}