Re: extract Top Ten order by date

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 26 Sep 2005 07:53:32 -0700
Message-ID: <1127746412.243861.238440@g14g2000cwa.googlegroups.com>

Marco, you only need one nested query in your example

  1 select ename
  2 from (select ename from emp order by ename)   3* where rownum = 1
UT1 > /

ENAME

---

ADAMS HTH -- Mark D Powell -- Received on Mon Sep 26 2005 - 09:53:32 CDT