Maybe it's a novice question, but I am trying to get the sum of balances for each account present in the table.
I am trying the below
Select SUM(BALANCE) from dbo.account_balances where ACCT IN ( 1000, 1001, 1002...)
This is giving me the total balance and I can see why. I need help in figuring out how to see the balances for each account individually in query result.
I do not have the rights to modify the table. There are no NULLs.