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
Can we use update in sql function?
What company owns postgresql?
What are the benefits of pl/sql packages?
how can we destroy the cookie? : Sql dba
How do you determine the current isolation level? : Transact sql
Why do you partition data?
How many types of triggers are there in pl sql?
What are the types of join in sql?
What is the primary use of normalization?
How to Declare Fixed Length String Value In PL SQL
What are variables in pl sql?
What are the advantages of sql?
Why do we use sql constraints?
How do you take the union of two tables in sql?
Why primary key is required?