Re: query help

Maybe this is what you are looking for ..

SQL> select * from test;

EL1                         EL2        EL3


-------------------- ---------- ----------

2                             1          4
3                             2          4
4                             2          3
5                             2          3
1                             1          5

SQL> select * from test
  2 where el1 in
  3 (select min(el1) from test where(el2,el3) in   4 (select el2,min(el3) from test group by (el2) )group by (el2,el3))   5 /

EL1                         EL2        EL3


-------------------- ---------- ----------

2                             1          4
4                             2          3