`CEIL`Numeric Functions

Returns the ceiling (smallest integer not less than x).

Syntax

CEIL(x)

Enter values below to update the example in real time.

total_amount→

rounded_up→

orders→

SELECT CEIL(total_amount / 10.0) * 10 AS rounded_up
FROM orders;