HTML 
CSS 
PHP 
JavaScript 
SQL 
Bootstrap 
Solidity 
jQuery 
Git 
Chrome DevTools 
C++ 
Python 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
- 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
- Free certificates of completion
- Focused on data science skills
- Flexible learning timetable
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
- A wide range of learning programs
- University-level courses
- Easy to navigate
- Verified certificates
- Free learning track available
- 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":
