Re: Selecting last n rows

If you can order the query, you can then select the first 10 rows using rownum:

select * from <table> where rownum<10;

Vince

Himanshu Gupta <himanshu.gupta_at_luton.ac.uk> a écrit dans le message : 3779D104.C4EFC45C_at_luton.ac.uk...
> How can I select last 10 rows from a table
> having more that 10,000 records?
>
> Thanks.
> Himanshu.
>
Received on Mon Jul 05 1999 - 15:22:25 CDT