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

When is a declare statement required?

1197

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

1125

What is difference between inner join and self join?

1137

What is sql constant?

1104

Is id a reserved word in sql?

1189

What type of database is cloud sql?

1160

Can function return multiple values in sql?

1098

How many rows can sqlite handle?

1162

Is it possible for a table to have more than one foreign key?

1084

Can we use ddl statements in stored procedure sql server?

1064

Is sqlexception checked or unchecked?

1013

what is the command used to fetch first 5 characters of the string? : Sql dba

1684

What is view explain with example?

1001

what are integrity rules?

1092

What is sql engine in oracle?

1040