[thelist] SQL- grouping and dates
Chris Evans
chris at fuseware.com
Tue Apr 3 10:41:46 CDT 2001
I have a SQL problem that seems like it should be easy, but it is driving me
crazy. Here is a sample of the data:
Root Message Updated
--------------------------
A abc 04/01/2001 04:00
B rgh 04/01/2001 06:03
A gha 04/01/2001 12:00
A 1jr 04/02/2001 06:03
B jus 04/03/2001 04:10
B jiu 04/03/2001 11:05
A qwe 04/03/2001 13:13
The result I want is:
A has 4 messages, the most recent updated at 04/03/2001 13:13
B has 3 messages, the most recent updated at 04/03/2001 11:05
I can get the counts with no problem, but picking up the LastUpdated date is
giving me headaches.
Suggestions?
Chris Evans
chris at fuseware.com
http://www.fuseware.com
More information about the thelist
mailing list