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

Why do we need databases?

1051

What is difference between left and right outer join?

991

what is bcp? When does it used? : Sql dba

991

Where not exists in sql?

983

what are different types of collation sensitivity? : Sql dba

1070

Is it possible to link two groups inside a cross products after the cross products group has been created?

1003

Explain the order of sql statement execution?

1049

What is string data type in sql?

1147

What is package in pl sql with an examples?

1039

what are the advantages of sql ? : Sql dba

1061

What does an inner join do?

1189

What is out parameter used for eventhough return statement can also be used in pl/sql?

1082

Explain the steps needed to create the scheduled job?

1041

When can we use the where clause and the having clause?

1021

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1096