Dofactory.com
Dofactory.com
Earn income with your data and sql skills
Sign up and we'll send you the best freelance opportunities straight to your inbox.
We're building the largest freelancing marketplace for people like you.
By adding your name & email you agree to our terms, privacy and cookie policies.

SQL POWER Function

POWER returns a value raised to a specified power.

The first parameter is the base and the second indicates the power.

Example

#

The example raises 2 to the power of 3.

SELECT POWER(2, 3) AS '2^3'
Result:  1 record
2^3
8

Syntax

Syntax of the POWER function.

POWER(base, power)

base -- a number indicating the base value.

power -- a number indicating the number of times the base is multiplied by itself.


You may also like



Last updated on Dec 21, 2023

Earn income with your data and sql skills
Sign up and we'll send you the best freelance opportunities straight to your inbox.
We're building the largest freelancing marketplace for people like you.
By adding your name & email you agree to our terms, privacy and cookie policies.