SQL POWER() Function

SQL POWER() Syntax

For MySql / Microsoft SQL SERVER

// For Input Number or Expression Value
SELECT POWER(X , Y);

Note:- The POWER() function returns a FLOAT value. Caution must be taken, however, with this function. The results will increase in size very quickly and can cause an overflow error.

SQL POWER() Example - Using Expression Or Formula

The following SQL SELECT statement returns the absolute value of a given input number or expression

SELECT POWER(2 , 3) AS 'Power Of 2 , 3';

Also we can write the above query in this way:

SELECT 2 * 2 * 2;

The result of above query is: