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. |
Theory is great, but we recommend digging deeper!
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":