How do you retrieve the last N records from a table?
- 10 Answers
- 16776 Views
- I also Faced
- E-Mail Answers
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
What does count (*) mean in sql?
How to avoid duplicate records in a query?
Enlist the data types that can be used in pl/sql?
Is null operator in sql?
Why functions are used in sql?
What are the basic sql commands?
How insert into statements in sql?
What program will open a mdb file?
What are the different set operators available in sql?
What are the limitations of sql express?
What is the difference between distinct and unique in sql?
What are records give examples?
What is primary key sql?
Explain how can you save or place your msg in a table?
What is t sql used for?
