How do you retrieve the last N records from a table?
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
What is program debugging?
What does varchar include?
How to assign sql query results to pl sql variables?
What is the difference between left outer join and left join?
What is sql partition function?
Can I call a procedure inside a function?
Does view store data in sql?
Is postgresql a nosql database?
What are % type and % rowtype?
What is a sql trace file?
How many databases can sql express handle?
what is a stored procedure? : Sql dba
Explain architecture of sql server notification services?
Is sql better than excel?
What are different types of indexes?