By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT pid, SUM(CASE WHEN drcr = 2 THEN Amount ELSE -Amount END)
FROM
(
VALUES
(1, 33, 1000, 1, 55),
(2, 32, 2000, 2, 44),
(3, 33, 1500, 2, 54)
) T(id, pid, amount, drcr, residce)
GROUP BY pid
| pid | (No column name) |
|---|---|
| 32 | 2000 |
| 33 | 500 |