RE: oracle last

2003-07-15 Thread Jamadagni, Rajendra
Title: RE: oracle last select name, sal from (select rownum rnum, name, sal from emp order by sal asc) where rownum 4 / ??? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email

Re: oracle last

2003-07-14 Thread Daniel Fink
Depending upon the version, you may be able to use the analytical functions (8.1.6+) to achieve what you want. I don't have a ready example, but the Oracle docs are pretty good. If you want a less elegant solution, use an inline query, sort by the reverse order (asc or desc depends on your