Re: Last inserted rows

Try for example

select empno, ename
from emp e
where 50 > (select count(*) from emp e2 where e2.empno > e.empno)
order by empno;

M

Azhdin wrote in message <7maqr0$931$1_at_news3.isdnet.net>...
>Hi,
>
>How can i get the last inserted row in a table order by a column.
>(ex : the 50 last insert)
>
>If i use the rownum option or the rowid, the order by statement is
>not correct.
>
>Thank's
>
>Azhdin
>email : aboulahouat_at_algoba.com
>
>
Received on Mon Jul 12 1999 - 02:57:00 CDT