query assistance -return most recent date
From: Rich_A2B (Rich_A2B_at_discussions.microsoft.com)
Date: 02/10/05
- Next message: Hugo Kornelis: "Re: query assistance -return most recent date"
- Previous message: shif: "err"
- Next in thread: Hugo Kornelis: "Re: query assistance -return most recent date"
- Reply: Hugo Kornelis: "Re: query assistance -return most recent date"
- Reply: Angelita Spear: "Re: query assistance -return most recent date"
- Messages sorted by: [ date ] [ thread ]
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?
- Next message: Hugo Kornelis: "Re: query assistance -return most recent date"
- Previous message: shif: "err"
- Next in thread: Hugo Kornelis: "Re: query assistance -return most recent date"
- Reply: Hugo Kornelis: "Re: query assistance -return most recent date"
- Reply: Angelita Spear: "Re: query assistance -return most recent date"
- Messages sorted by: [ date ] [ thread ]