G
Guest
Is there a way to query a table like this and get a return of only the latest
date for all distinct names in column A?
Column A
Column B
Infrastructure Availability Managers 02/07/2004
11:59:00 PM
Infrastructure Availability Managers 01/22/2005
11:59:00 PM
CNCC Support Services 07/30/2004
11:59:00 PM
CNCC Support Services 08/12/2006
11:59:00 PM
I only want Infrastructure Availability Managers 02/22/2005 11:59:00 PM
and CNCC Support Services 08/12/2006
11:59:00 PM.
Thanks in advance.
date for all distinct names in column A?
Column A
Column B
Infrastructure Availability Managers 02/07/2004
11:59:00 PM
Infrastructure Availability Managers 01/22/2005
11:59:00 PM
CNCC Support Services 07/30/2004
11:59:00 PM
CNCC Support Services 08/12/2006
11:59:00 PM
I only want Infrastructure Availability Managers 02/22/2005 11:59:00 PM
and CNCC Support Services 08/12/2006
11:59:00 PM.
Thanks in advance.