SQL · Numeric functions

ceil() / floor()

Rounds up or down to an integer.

sqlRunnable example sql course

Syntax

ceil(number) / floor(number)

Example

Open in the lab

SELECT ceil(2.1) AS up, floor(2.9) AS down;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.