select * from t_milestones a
where a.status = 'not reached'
a.end_date = (select min(end_date)
from t_milestones)
longinus <longinus_at_zeus.polsl.gliwice.pl> wrote in message
news:3BF99E37.CD498962_at_zeus.polsl.gliwice.pl...
> 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 NUMBER
Received on Mon Nov 19 2001 - 19:10:47 CST
