HTML
CSS
PHP
JavaScript
SQL
Bootstrap
Solidity
jQuery
Git
Chrome DevTools
C++
PythonContents
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
- Professional service
- Flexible timetables
- A variety of features to choose from
- Professional certificates of completion
- University-level courses
- Multiple Online degree programs
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":
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