Interested to Buy Any Domain ? << Click Here >> for more details...
How do you retrieve the last N records from a table?
- 10 Answers
- 18456 Views
- I also Faced
- E-Mail Answers
Answer Posted / sunil bisht
Last 10 record from emp table
select * from emp where rowid<=(select max(rowid) from emp)
minus select * from emp where rowid in(select rowid from
emp where rownum<=3);
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Is pl sql and postgresql same?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
What is t sql used for?
How do I view a sql trace file?
How can we debug in PL/SQL?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
Explain constraints in sql?
What are the two types of periodical indexes?
What are records give examples?
How to place comments in pl/sql?
What is a loop in sql?
how to create a new view in mysql? : Sql dba
What is the order of sql select?
What are the disadvantages of not performing database normalization?
Can there be more than one function with a similar name in a pl/sql block?
