[thelist] SQL... group by prob...

Tris beertastic at gmail.com
Tue Sep 18 08:18:06 CDT 2007


We've a table.. (lucky us)

offer_id, date

it's populated with many offer_id's (we've say 20 offers)
and each time a user digns up, we flag what offer and the date (Unix time stamp)

What we want to do is list each offer_id (group by offer_id)
but lsit the most recent date for each unique offer listing...

Am I being a tool...?
GROUP BY offer_id ORDER BY date DESC doesn't work...

how can I do this? :-(

Give a man a fish and he'll feed himself for a day.
Give a man a religion and he'll starve to death praying for a fish.

`We are what we pretend to be, so we must be careful what we pretend to be.`
Kurt Vonnegut

`When a person can no longer laugh at himself, it is time for others
to laugh at him.`
Thomas Szasz

More information about the thelist mailing list