CEIL (Lakehouse v1)
Rounds the number up.
Analyze Syntax
Section titled “Analyze Syntax”func.ceil( <x> )Analyze Examples
Section titled “Analyze Examples”func.ceil((- 1.23))
┌─────────────────────┐│ func.ceil((- 1.23)) │├─────────────────────┤│ -1 │└─────────────────────┘SQL Syntax
Section titled “SQL Syntax”CEIL( <x> )Aliases
Section titled “Aliases”SQL Examples
Section titled “SQL Examples”SELECT CEILING(-1.23), CEIL(-1.23);
┌────────────────────────────────────┐│ ceiling((- 1.23)) │ ceil((- 1.23)) │├───────────────────┼────────────────┤│ -1 │ -1 │└────────────────────────────────────┘