Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT batchno, -- or drugid
- SUM(CASE type WHEN 'i' THEN qty -- inward
- WHEN 'o' THEN -qty -- outward
- ELSE 0 -- unknown
- END) balance
- FROM stock_table
- GROUP BY batchno -- or drugid
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement