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 a data definition language?

1029

Can we call procedure in select statement?

976

In what condition is it good to disable a trigger?

971

What is pl/sql table? Why it is used?

991

What is an ndf file?

927

What is sql lookup?

865

How many aggregate functions are available there in sql?

931

what is meant by nl2br()? : Sql dba

975

Does sql require a server?

945

What is a scalar value in sql?

1014

How to use transactions efficiently : transact sql

993

Is drop table faster than truncate?

942

What is recursive join in sql?

948

i have some prob lem to tell me about my self in interview first round ...

2116

When is a declare statement required?

1083