Syntax of POWER Function :
POWER (numeric_expression, y)
numeric_expression is a number value of type numeric or approximate numeric except bit.
y is value for power to which to raise a number specified as numeric_expression. It is of type numeric or approximate numeric except bit.
Return type of POWER function is same as numeric_expression.
Examples of POWER Function :
Example 1 : Use of POWER function in select clause
SELECT POWER(2,3)
Output
8
Above example returns value for 2 raise to 3 expression.
Example 2 : Use of POWER function in select clause
Output
Above example return value for -3 raise to -2 expression.