Please start any new threads on our new
site at http://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Our new SQL Server Forums are live!
Come on over! We've restricted the ability to create new threads on these forums.
Flowing Fount of Yak Knowledge
quote:Originally posted by ayyoob1234hii have to extract a list of accounts where balance < 10000a/c_id start_dt end_dt balanceB12345 01-01-2007 25-06-2007 15000 B12345 26-05-2007 01-10-2007 15000 B12345 02-10-2007 31-12-2099 25000 my code is as follow :select a/c_id, sum(balance)from tablewhere sum(balance) > 10000group by a/c_idplzzz help
select a/c_id, sum(balance)
group by a/c_id
HAVING sum(balance) > 10000
Very Important crosS Applying yaK Herder