group by date

[yuchieh]

I have a table that stores donation information - name, transaction_date, amount, fund

how do I select:
total amount >= $100 accumulated in one day, by one person?
and yet, I need to display details. in other words, display individual records if the total amount belongs to multiple funds.

Thanks

 

[RiverGuy]

You do this in two pieces. First, find the aggregate criteria, then join to the details

SELECT b.*, a.DailyAmount
FROM

(SELECT 
DateColumn,
PersonColumn,
SUM(Amount) AS DailyAmount
FROM YourTable
GROUP BY DateColumn, PersonColumn
HAVING SUM(Amount) >= 100) a

INNER JOIN

YourTable b

ON a.DateColumn = b.DateColumn
AND a.PersonColumn = b.PersonColumn

 

[yuchieh]

I think I got it.

Thanks much.