getting top 10 rows

[sumit malik]

hi,
i hav one simple but ?? problem..can any one tell me how to fetch first 10 or last 20 rows from a table which contains 100 records...
thanx in advance...

[Remar Uy]

select *
from emp
where rownum < 11
/

[sumit malik]

Originally posted by Remar Uy:
select *
from emp
where rownum < 11
/

thanx...but i think this is not a proper solution ...i guess there r some functions like TOP to fetch rows...and how can i fetch last 40 rows ..using this method..

[Lipman Li]

select * from
(select * from emp order by rownum desc)
where rownum < 41;
you'll get the last 40 records.

[SJ Adnams]

select name from
(select rownum a, name from emp )
where a > 60
?

[Remar Uy]

Hi,
If you're using 8.1.7 and above, you can use Rank.
Hth.