By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| COL | CASEWHENMOD(COL,1)=0.5THENCOLELSEROUND(COL)END |
|---|---|
| 9115.7 | 9116 |
| 9115.5 | 9115.5 |
| 9116.5 | 9116.5 |
| 9115.3 | 9115 |
4 rows affected
| COL | CASEWHENMOD(COL,1)=0.5THENCOLELSEROUND(COL)END |
|---|---|
| 9115.7 | 9116 |
| 9115.5 | 9115.5 |
| 9116.5 | 9116.5 |
| 9115.3 | 9115 |