 |
|
SQL Round Function & Floor Function
Round Function
| SQL | Result |
|---|
| SELECT ROUND(10.17,0) | 10 |
| SELECT ROUND(10.17,1) | 10.2 |
| SELECT ROUND(10.17,2) | 10.17 |
| SELECT ROUND(10.50,0) | 11 |
| SELECT ROUND(10.76,0) | 11 |
Floor Function
| SQL | Result |
|---|
| SELECT FLOOR(10.17,0) | 10 |
| SELECT FLOOR(10.50) | 10 |
| SELECT FLOOR(10.76) | 10 |
|
|
