and need output like this
Thanks and Regards
Try the below:
Select Column,Sum(Amount) From Table_Name
Group by Column having Sum(Amount)<>0
Please use Marked as Answer if my post solved your problem and use
Vote As Helpful if a post was useful.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?