Summary - Number functions

Combine ROUND, ABS and MOD to do calculations.

In this group you learned ROUND, CEIL, FLOOR, ABS, POWER, SQRT and MOD. Choosing the right function matters in calculations.

SELECT ROUND(SQRT(16), 0) AS sonuc;

This query takes the square root of 16 and rounds to an integer.

The expression ROUND(SQRT(16), 0) AS sonuc is evaluated and returned.

Exercise Summary - Number functions

Select the square root of price aliased as kok from products.

Show example solution

SELECT SQRT(price) AS kok
FROM products