Black friday

Save big!

All courses under $5 - for a limited time!

Code has been added to clipboard!

How to Use the SQL ROUND Function

Reading time 1 min
Published Aug 9, 2017
Updated Oct 11, 2019

SQL ROUND Function: Main Tips

  • This function is needed in order to round a field containing numbers to the defined decimal numbers.
  • Most of the database systems are using the IEEE 754 standard. Which rounds .5 to the closest integer which is even. That means 10.5 and 11.5 will both become 11.

Syntax of SQL ROUND

Example
ROUND(decimal, col_name)
Parameters Descriptions
col_name Needed. The data record to be rounded.
decimal Needed. Defines the amount of decimals to be brought.
Theory is great, but we recommend digging deeper!

Demo Database

The example table "Products":

ID Name Supplier_ID Category_ID Unit Price Unit_in_stock Unit_on_order
1 Cucumber 3 3 5 crates 19 17 16
2 Tomato 3 3 6 crates 20 24 Null
3 Cheese 3 4 5 kg boxes 11 11 6
4 Milk 4 4 5 L bottles 22 56 12
5 Bread 4 4 36 boxes 26 26 1

SQL ROUND: Example

The code example below picks out the name of the product and uses the Round function in the table "Products":

Example
SELECT Name, ROUND(Price,0) as UnitsPrice FROM Products