By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| op | name | amount | total |
|---|---|---|---|
| 1 | a | 120 | 6 |
| 2 | a | 120 | 6 |
| 5 | b | 80 | 12 |
| 6 | b | 80 | 12 |
| 1 | c | 50 | 5 |
| 3 | c | 50 | 5 |
6 rows affected
| op | name | amount | total |
|---|---|---|---|
| 1 | a | 120 | 6 |
| 2 | a | 120 | 6 |
| 5 | b | 80 | 12 |
| 6 | b | 80 | 12 |
| 1 | c | 50 | 5 |
| 3 | c | 50 | 5 |