Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ranking style query

ranking style query

From: ben <ben_at_intrinsica.co.uk>
Date: 22 May 2002 04:10:39 -0700
Message-ID: <5bee31fb.0205220310.47453ccb@posting.google.com>


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



a1, e3, 13/12/2002
a2, e4, 14/12/2002

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US