SQL Server - CEILING() Function

The SQL Server (Transact-SQL) CEILING() function returns the next highest integer value by rounding up the specified number, if necessary. In other words, it rounds the fraction UP of the given number.

Syntax

CEILING(x)

Parameters

Return Value

Returns the next highest integer value by rounding UP the specified number, if necessary.

Example 1:

The example below shows the usage of CEILING() function.

SELECT CEILING(23);
Result: 23

SELECT CEILING(23.3);
Result: 24

SELECT CEILING(23.8);
Result: 24

SELECT CEILING(-23);
Result: -23

SELECT CEILING(-23.3);
Result: -23

SELECT CEILING(-23.8);
Result: -23

Example 2:

Consider a database table called Sample with the following records:

The statement given below can be used to round the fraction UP for all records of column x.

SELECT *, CEILING(x) AS CEILING_Value FROM Sample;

This will produce the result as shown below: