query assistance -return most recent date

From: Rich_A2B (Rich_A2B_at_discussions.microsoft.com)
Date: 02/10/05


Date: Thu, 10 Feb 2005 09:17:01 -0800

I have a table that has two fields, pkg_num, which is a number, and
del_date_time, which is a date-time. The table can contain duplicate pkg_num
values, as long as the del_date_time values are different for any given
number. I need a query that will return the most recent del_date_time for
each pkg_num. Any ideas?