Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 55 of 81

MySQL Functions — Question 6

Back to all questions
6
Question

Question 2(v)

Explain the POWER() SQL function using suitable examples.

Answer

The POWER()/POW() function returns the value of m raised to the nth power, denoted as mn. The syntax is POWER(m, n) or POW(m, n). Both m and n can be any numbers, but if m is negative, n must be an integer. For example,

SELECT POWER(4, 2) "Raised";
Output
+--------+
| Raised |
+--------+
|     16 |
+--------+