SQL Tutorial

SQL POWER Function

The SQL POWER function returns the <numeric_expression> raised to the power of <power>. Here is the syntax:

	POWER(<numeric_expression>,<power>)

Here is a query example which 10 is raised to power of 2:

SELECT POWER(10,2) AS power_value

And the output is:

power_value
-----------
        100
Read On