SQL Tutorial SQL Advanced SQL Database SQL References

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

x Required. Specify a number.

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:

Datax
Data 1-10.75
Data 2-5.38
Data 30.98
Data 413.16
Data 548.13

The query 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:

DataxCEILING_Value
Data 1-10.75-10
Data 2-5.38-5
Data 30.981
Data 413.1614
Data 548.1349

❮ SQL Server Functions

5