select * from ( select e1.* from em

How do you retrieve the last N records from a table?

Question Posted / swastik

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

Please Help Members By Posting Answers For Below Questions

What are sql constraints?

1228

What are conditional predicates?

1127

How do rank () and dense_rank () differ?

1109

How does sql profiler work?

1065

what is cross join? : Sql dba

1050

How to prepare for oracle pl sql certification?

1109

What are types of exception?

963

What is the difference between rollback and rollback to statements?

1100

Explain what is dbms?

1120

Is sql a oracle?

1022

What is sql and its types?

1253

How many clustered indexes can you have?

1037

What is full join in sql?

1035

Explain lock escalation? : Transact sql

1268

What is trigger explain it?

1078