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
hi
is there a statement like last in mysql ?
last returns a specified number of rows from a select.
means if i do a select and i want only the last 3 lines.
thx
martin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: pfeffer
INET: [EMAIL PROTECTED]
Fat City Network
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