Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

POWER

Example

Return 4 raised to the power of 2.

SELECT POWER(42);

Definition and Usage

The POWER() function calculates the value of a number raised to the power of another number.

Note: This function is equivalent to the POW() function.

Syntax

POWER(x, y)

Parameter Values

Parameter

Description

x

Mandatory: A numerical value (the base)

y

Necessary: A numerical value (the exponent)

Technical Details

Works in:

From MySQL version 4.0

More Examples

Example

Compute the result of raising 8 to the power of 3.

SELECT POWER(83);