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. |
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":