Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL query
How to choose using SQL language the record that has status 'not
reached' and the minimal end_date?
table description:
SQL> desc t_milestones
Name Null? Type ------------------------------- -------- ---- NAME VARCHAR2(50) DEADLINE VARCHAR2(10) END_DATE VARCHAR2(10) STATUS VARCHAR2(15) MILESTONESID NOT NULL NUMBER(5) PROJ_ID NUMBERReceived on Mon Nov 19 2001 - 18:05:11 CST