How do you retrieve the last N records from a table?
- 10 Answers
- 16774 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
Where the sql database files are stored?
Is sql better than excel?
How do I save the results of sql query in a file?
What is primary and foreign key?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
what is an alias command? : Sql dba
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What does where 1/2 mean in sql?
What is optimistic concurrency control? : Transact sql
What is audit logout in sql profiler?
What is cursor and its types?
What is sharding in sql?
What do we need to check in database testing?
What are types of joins?
how to run 'mysql' commands from a batch file? : Sql dba
