How to Round Up in SQL
In SQL, you round up to the nearest integer using the
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
Rounding Up in Oracle, MySQL, and PostgreSQL
In Oracle, MySQL, and PostgreSQL, you can use either the
CEILING() function to round up.
Author: Nat Dunn
Nat Dunn is the founder of Webucator (www.webucator.com), a company that has provided training for tens of thousands of students from thousands of organizations. Nat started the company in 2003 to combine his passion for technical training with his business expertise, and to help companies benefit from both. His previous experience was in sales, business and technical training, and management. Nat has an MBA from Harvard Business School and a BA in International Relations from Pomona College.
Follow Nat on Twitter at @natdunn and Webucator at @webucator.