Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> ranking style query
Hi,
I have a table which looks sort of like this:
ID1, ID2, PlannedDate, ActualDate
a1, e1, 10/12/2002, 10/12/2002 a1, e2, 11/12/2002, 11/12/2002 a1, e3, 13/12/2002, null a1, e4, 15/12/2002, null a1, e5, 18/12/2002, null a1, e6, 21/12/2002, null a2, e1, 10/12/2002, 10/12/2002 a2, e2, 11/12/2002, 11/12/2002 a2, e3, 14/12/2002, 14/12/2002 a2, e4, 19/12/2002, null
I need to pull out the ID1 and ID2 fields where actualdate is null and the planned date is the minimum planned date.
so I would like to get out:
ID1, ID2, PlannedDate
I cannot figure out how to get this from the table. Any ideas?
thanks very much in advance
Ben Received on Wed May 22 2002 - 06:10:39 CDT