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.
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
Coursera
Pros
  • Professional service
  • Flexible timetables
  • A variety of features to choose from
Main Features
  • Professional certificates of completion
  • University-level courses
  • Multiple Online degree programs
Datacamp
Pros
  • Great user experience
  • Offers quality content
  • Very transparent with their pricing
Main Features
  • Free certificates of completion
  • Focused on data science skills
  • Flexible learning timetable

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

Latest Udacity Coupon Found:

Verified STAFF PICK

75% OFF COURSES

Udacity Black Friday Offer

The best time to save on Udacity courses is now - follow this coupon to access a 75% Udacity Black Friday discount & enjoy learning at a very low cost!

Expiration date: 28/02/2021
3176 People Used
Only 97 Left
Rating
5.0