-
Hi
Is there any way I can get the data for the last 10 rows of a table
regards
-
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
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|