🚨 Time is Running Out: Reserve Your Spot in the Lucky Draw & Claim Rewards! START NOW

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.
DataCamp
Pros
  • Easy to use with a learn-by-doing approach
  • Offers quality content
  • Gamified in-browser coding experience
  • The price matches the quality
  • Suitable for learners ranging from beginner to advanced
Main Features
  • Free certificates of completion
  • Focused on data science skills
  • Flexible learning timetable
Udacity
Pros
  • Simplistic design (no unnecessary information)
  • High-quality courses (even the free ones)
  • Variety of features
Main Features
  • Nanodegree programs
  • Suitable for enterprises
  • Paid Certificates of completion
edX
Pros
  • A wide range of learning programs
  • University-level courses
  • Easy to navigate
  • Verified certificates
  • Free learning track available
Main Features
  • University-level courses
  • Suitable for enterprises
  • Verified certificates of completion

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