POWER and SQRT

Take powers and square roots.

POWER(x, y) returns x raised to y; SQRT(x) returns the square root.

SELECT POWER(2, 10) AS iki_us, SQRT(16) AS kok;

2 to the 10th = 1024; square root of 16 = 4.

The expression POWER(2, 10) AS iki_us, SQRT(16) AS kok is evaluated and returned.

POWER and SQRT — details

POWER(2, 3) = 8. SQRT errors on negative numbers. You can also use POWER(x, 0.5) instead of SQRT.

Select the square root of 16 aliased as kok.

Next lesson: MOD