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

Does a join table need a primary key?

905

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

993

Is primary key clustered or nonclustered?

954

What is the purpose of design view?

952

Is postgresql a nosql database?

1079

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

947

explain normalization concept? : Sql dba

998

What are some emotional triggers?

931

Can delete statement be rollbacked?

932

What is the usage of nvl function?

984

What are aggregate and scalar functions?

978

What language is oracle sql developer?

941

Name the different types of indexes in sql and define them.

1077

How do I debug a stored procedure?

1042

How can get second highest salary in sql?

912