SQL*plus Query -- Very urgent

[pando]

select * from
(select * from emp order by deptno) a
where rownum = 1



[Edited by pando on 07-18-2002 at 02:36 PM]