[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