How do you retrieve the last N records from a table?
Answer Posted / swastik
select
* from
(
select e1.*
from emp e1
order by rownum desc
)
where rownum <= &n
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you modify a table in sql?
discuss about myisam index statistics collection. : Sql dba
What is self-join and what is the requirement of self-join?
what are sequences
what is a tablespace? : Sql dba
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
How can the performance of a trigger be improved?
Why trigger is used in sql?
Does group by remove duplicates?
What is an intersect?
What is the maximum number of triggers, you can apply on a single table?
Explain spool.
What is the difference between inner join and left join?
What is the command used to fetch first 5 characters of the string?
is it possible to pass an object or table to a procedure as an argument?