Cancel the pair off which is coming as zero

[Sshasnk]

I have multiple transactions from salary and I have to figure out the pair which is sum is not equal to zero

From the example below:  Salary Id;123 => 7000+(-7000) = zero-> Eliminate

                                          Salary Id 123 => 14200 + 2000+8800 = 25000 (which is equal to salary amount) -> Keep it

Same goes for                   Salary Id 789 => 789 => -2500 + (-2500 )= -5000 (which is equal to salary amount) -> keep it 

Note: The Idea is to eliminate the pair which is coming as zero

salary_Id	Transaction	salary
123	7000	25000
123	-7000	25000
123	14200	25000
123	2000	25000
123	8800	25000
123	-8000	25000
123	8000	25000
456	3800	8800
456	5000	8800
789	-2500	-5000
789	-2500	-5000

Output:

salary_id	Transaction	salary
123	14200	25000
123	2000	25000
123	8800	25000
456	3800	8800
456	5000	8800
789	-2500	-5000
789	-2500	-5000

[DavidP · Accepted solution]

Does this give you what you want?

[PhilippK · Accepted solution]

Hi @Sshasnk ,

please find the solution attached:

 Is this the solution you were looking for?

Best regards

Phil