Re: Comparing rows keeping latest

[Grygonos]

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

[Anonymous Monk]

Thanks, I think that should work... I wil have to go look up the syntax. Thanks again all for all your help...

[Grygonos]

The syntax of the query I provided, should be ANSI compliant. I don't know how much you would need to change.

---

Grygonos