How to Round Up in SQL

See SQL: Tips and Tricks for similar articles.

In SQL, you round up to the nearest integer using the CEIL or CEILING function, depending on whether you're using SQL Server, Oracle, MySQL or PostgreSQL.

Rounding up in SQL Server

In SQL Server, you round up with the CEILING() function.

SELECT CEILING(5.2)
Output:
6

Rounding Up in Oracle, MySQL, and PostgreSQL

In Oracle, MySQL, and PostgreSQL, you can use either the CEIL() or CEILING() function to round up.

SELECT CEIL(5.2)
SELECT CEILING(5.2)
Output:
6