On 10/12/06, Phil Turmel <philip at turmel.org> wrote: > You didn't mention what DB platform, but they'll all be similar if they > support subqueries. Something like this: Oracle > Select status, Count(widgetid) As wcount > From (Select status, widgetid, Max(date_updated) As date_lastupdated > From WIDGET_STATUS > Where date_updated Between '20060501' And '20060601' > Group By status, widgetid) > Group By status > Order By wcount Desc; Very cool. I was using the max() subquery method that others suggested. I hadn't thought of this. -- Matt Warden Cleveland, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy.