bugl
bugl
HomeLearnPatternsSearch
HomeLearnPatternsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

SQL Server POWER() Function

Concept visual

SQL Server POWER() Function

Pointer walk
two pointers
leftright102132436485116
left=0
right=6
1
3

Start at both ends

Example

Return 4 raised to the second power:

SELECT POWER(4, 2);

Definition and Usage

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

Syntax

Power(

a, b )

Parameter Values

Parameter

Description a

Required. A number (the base) b Required. A number (the exponent)

Technical Details

Works in:

SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

More Examples

Example

Return 8 raised to the third power:

SELECT POWER(8, 3);

Previous

❮ SQL Server Functions

Next

Previous

SQL Server PI() Function

Next

SQL Server RADIANS() Function