By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
12 rows affected
| ID | TYPE | SUMVAL | DIFF |
|---|---|---|---|
| A | MS | 7 | 0 |
| A | MSH | 16 | -9 |
| A | MSO | 7 | 0 |
| B | MS | 1 | 0 |
| B | MSH | 13 | -12 |
| B | MSO | 8 | -7 |
12 rows affected
| ID | TYPE | SUMVAL | DIFF |
|---|---|---|---|
| A | MS | 7 | 0 |
| A | MSH | 16 | -9 |
| A | MSO | 7 | 0 |
| B | MS | 1 | 0 |
| B | MSH | 13 | -12 |
| B | MSO | 8 | -7 |