How to Round Up in SQL

  • google plus

In Brief...

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.

Instructions

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

Author: Nat Dunn

Nat Dunn founded Webucator in 2003 to combine his passion for web development with his business expertise and to help companies benefit from both.

Discuss