Guest
I have a table with 3 columns, clientID, salesID and date with data such as
10001,1,5/20/2001
10001,2,5/22/2001
10001,3,5/21/2001
10002,2,5/24/2001
10002,3,5/25/2001
etc
How do I select distinct clientID so that the one selected has the max date? that is, I need the result:
10001,2,5/22/2001
10002,3,5/25/2001
etc
Many thanks
10001,1,5/20/2001
10001,2,5/22/2001
10001,3,5/21/2001
10002,2,5/24/2001
10002,3,5/25/2001
etc
How do I select distinct clientID so that the one selected has the max date? that is, I need the result:
10001,2,5/22/2001
10002,3,5/25/2001
etc
Many thanks