CEIL and FLOOR

Round numbers up and down.

CEIL rounds a number up, FLOOR rounds down. CEIL always returns an integer greater or equal.

SELECT CEIL(price) AS up, FLOOR(price) AS down FROM products;

This query returns the rounded-up and rounded-down price.

CEIL(price) AS up, FLOOR(price) AS down is selected from products.

CEIL and FLOOR — details

CEIL(4.2) = 5, FLOOR(4.8) = 4. For negative numbers CEIL goes toward zero, FLOOR away from zero.

Select the ceiling of price aliased as up from products.

Show example solution

SELECT CEIL(price) AS up
FROM products

Round down

SELECT ____(price) FROM products;

Show answer

SELECT FLOOR(price) FROM products;

Next lesson: ABS