in reply to Comparing rows keeping latest

Assuming you're the one writing the query, a simple SELECT MAX(Date) As MaxDate,ID FROM tblFoobar GROUP BY ID will get you exactly what you want. Leaving this problem to Perl is not the best approach IMHO

Grygonos

Replies are listed 'Best First'.
Re^2: Comparing rows keeping latest
by Anonymous Monk on Feb 20, 2006 at 20:53 UTC
    Thanks, I think that should work... I wil have to go look up the syntax. Thanks again all for all your help...
[reply]
      The syntax of the query I provided, should be ANSI compliant. I don't know how much you would need to change.
      Grygonos
[reply]

In Section Seekers of Perl Wisdom