CEILING()

The SQL function CEILING() is used to round up a numeric value to the next highest integer. It returns the next whole value that is greater than or equal to the input value.

Syntax

SELECT CEILING(value)
FROM table_name;

• value - This is the value to be rounded up.

Example

The following data is given in a temperatures table:

The CEILING() function can be used to round up the raw temperatures:

SELECT temp_id, CEILING(raw_temp) AS ceil_temp
FROM temperatures;

The output will be: