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

POW

Example

Provide the result of raising 4 to the power of 2.

SELECT POW(4, 2); 

Definition and Usage

The POW() function yields the result of a number raised to a specified power.

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

Syntax

POW(x, y)

Parameter Values

Parameter

Description

x

Mandatory: A numerical value representing the base.

y

Mandatory: A numerical value representing the exponent.

Technical Details

Works in: From MySQL 4.0

More Examples

Example

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

SELECT POW(8, 3);