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 is pls integer?

1016

What is the difference between truncate and drop statements?

1164

what are numeric data types? : Sql dba

1046

How to write html code in pl sql?

1097

What is the use of function "module procedure" in pl/sql?

1182

What is the sql case statement?

978

What is self-join and what is the requirement of self-join?

1130

How much does a sql dba make? : SQL DBA

927

Explain foreign key in sql?

1006

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1245

Is record in oracle pl sql?

943

How do I debug a stored procedure?

1093

What is null in pl/sql?

1046

How can we debug in PL/SQL?

1118

How do you concatenate in sql?

1013