Contents
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. |

Pros Main Features
- Simplistic design (no unnecessary information)
- High-quality courses (even the free ones)
- Variety of features
- Nanodegree programs
- Suitable for enterprises
- Paid certificates of completion

Pros Main Features
- Easy to navigate
- No technical issues
- Seems to care about its users
- Huge variety of courses
- 30-day refund policy
- Free certificates of completion

Pros Main Features
- Great user experience
- Offers quality content
- Very transparent with their pricing
- 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":