Last rows of a table

[puneet]

Hi

Is there any way I can get the data for the last 10 rows of a table

regards

[pras]

hi
pls try this query and let me know whether it worka or not

select empno from emp where rownum <(select max(rownum) from emp)
minus
select empno from emp where rownum <(select max(rownum)-10 from emp);

hope this will help u
pras

[puneet]

Thanks

It works