SQL question

Associate
Joined
23 Aug 2004
Posts
1,493
Hi, I have a set of records.


X8973 PACKAGING 1 1.4948 1 06/12/2005 E2640
X8973 PACKAGING 1 1.4948 1 31/10/2001 E2641
09234 PACKAGING 1 8.0187 5 09/12/2004 E2640
09234 PACKAGING 1 8.0187 8 05/05/2004 E2641

Simply, I would like to select records with the most recent dates. Leaving me with

X8973 PACKAGING 1 1.4948 1 06/12/2005 E2640
09234 PACKAGING 1 8.0187 5 09/12/2004 E2640

Can anyone suggest how this is done?
 
Back
Top Bottom