CEILING
Syntax
CEILING( number )
Description
Rounds the value up to the nearest integer.
Argument types:
number
—Fractional number | Integer
Return type: Fractional number
Examples
CEILING(5.37) = 6
Data source support
Materialized Dataset
, ClickHouse 1.1
, Microsoft SQL Server 2017 (14.0)
, MySQL 5.6
, Oracle Database 12c (12.1)
, PostgreSQL 9.3
.