This content cannot be displayed without JavaScript.
Please enable JavaScript and reload the page.

CEILING

The CEILING function rounds an input value to the nearest integer that is greater than it.

Syntax

SELECT CEILING(…)
CEILING(constant)
CEILING(fact)
CEILING(metric)
CEILING(metric_expression)

Examples

SELECT CEILING(12.2) = 13
SELECT CEILING(12.7) = 13

Was this information helpful?

Thank you! We're glad you found what you needed. Feedback is important to us.

If you want to provide more feedback, subscribe to participate in our feedback sessions.

Thank you for your feedback!

If you can't find what you need, don't hesitate to send us a comment.