select * from emp a where &N > (select count(*) from emp b where b

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

Question Posted / nani

Answer Posted / nani

select * from emp a where &N > (select count(*) from emp b
where b.rowid > a.rowid)

N = No.of rows.

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What has stored procedures in sql and how we can use it?

1082

How can we store rows in PL/SQL using array?

1220

Can we commit in trigger?

978

What is scalar data type in pl sql?

1070

what are the advantages and disadvantages of views in a database? : Sql dba

1043

What is bind variable in pl sql?

1053

What is the purpose of my sql?

951

How many developers work on postgresql?

983

What is data control language (dcl)?

1138

Does view contain data?

1037

What is indexing in sql and its types?

1080

What kind of join is join?

972

what is the difference between $message and $$message? : Sql dba

998

What is a full join sql?

1057

What is interval partition?

1055