[RESOLVED] SUM and subselect?

[fikse]

sample dataset for vip_contributions table:

=================
vipID, contributionamount
3, 10.00
3, 25.00
3, 100.00
4, 10.00

4, 5.00

I need to select all vipID's that have total contributions over 100.....

I have this query:

=================
SELECT distinct vipID, SUM(contributionamount) as totalcontributions

FROM vip_contributions

GROUP BY vipID

which gives me the vipID and the total, but need to add a subselect of somekind to return only the vipID's that have a total over 100.....

any ideas would be great!

[devinemke]

SELECT distinct vipID, SUM(contributionamount) as totalcontributions FROM vip_contributions GROUP BY vipID HAVING SUM(contributionamount) > 100 

[fikse]

perfect... thank you very much.....