sql question

From: amy <amykline_at_gmail.com>
Date: Thu, 10 Sep 2009 10:41:42 -0700 (PDT)
Message-ID: <41f0f03b-4efa-4c6c-b8b7-ce230b87344c_at_s31g2000yqs.googlegroups.com>

I don't seem to be able to figure this out using distinct, group by or the having clause. Can someone help?

I have a table with the following records. If there are any duplicate IDs, I would like to just list the record with the latest timestamp.

        ID NAME COLDATE
---------- ----- --------------------

         1 G     09-sep-2009 10:20:02
         1 J     10-sep-2009 10:20:31
         1 L     10-sep-2009 10:21:00
         2 H     10-sep-2009 10:20:17
         3 K     31-aug-2009 10:20:43

The result I'm expecting is

        ID NAME COLDATE
---------- ----- --------------------

         1 L     10-sep-2009 10:21:00
         2 H     10-sep-2009 10:20:17
         3 K     31-aug-2009 10:20:43

Can someone help? thanks in advance. Received on Thu Sep 10 2009 - 12:41:42 CDT