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