bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

SQL Server POWER() Function

Example

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

ParameterDescription
aRequired. A number (the base)
bRequired. A number (the exponent)

Technical Details

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

Previous

SQL Server PI() Function

Next

SQL Server RADIANS() Function