How to Round Numbers in SQL

Rounding Numbers in SQL

Do you need to round numbers in your SQL database? You're in luck! SQL has a handy way of rounding numbers that can help you get the result you need.

The Solution

The solution is to use the ROUND() function. This function takes two arguments: the number you want to round and the number of decimal places you want to round to. For example, if you wanted to round the number 3.14159 to two decimal places, you would use the following query:

SELECT ROUND(3.14159, 2);

This query would return the result 3.14.

Examples

Suppose you have a table called sales with a price column. If you wanted to round the prices in this table to two decimal places, you would use the following query:

SELECT product, ROUND(price, 2) FROM sales;

For financial reporting, round at the last step only. Every intermediate rounding compounds error.

Additional Info

The ROUND() function is supported by most major databases, including MySQL, PostgreSQL, and SQL Server. Syntax may vary slightly — check your engine's documentation.