Posted by patelk23 on 12/08/06 09:53

Hi everyone,
I am really struggling to do the following in sql. Your expertise will
be very welcome.

I have a table [TestData] below


IndexId IndexVersion LastAmendedWhen
---------- --------------- -------------------
29 1 06/10/2006 17:40:43
29 2 06/10/2006 17:41:29
29 3 09/10/2006 12:19:33
29 4 09/10/2006 12:20:03
29 5 10/10/2006 10:53:32

I want to pick out rows with the lastAmendedWhen for each dates. So my
output should look like
IndexId IndexVersion LastAmendedWhen
---------- --------------- -------------------
29 2 06/10/2006 17:41:29
29 4 09/10/2006 12:20:03
29 5 10/10/2006 10:53:32

Please can someone help. I am really struggling with this.

[Back to original message]