Last 10 record from emp table select * from emp where rowid<=(select

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

Question Posted / sunil bisht

10 Answers
18725 Views
I also Faced
E-Mail Answers

Answer Posted / sunil bisht

Last 10 record from emp table

select * from emp where rowid<=(select max(rowid) from emp)
minus select * from emp where rowid in(select rowid from
emp where rownum<=3);

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is oracle sql free?

1039

What are pl/sql packages?

1161

What is structural independence and why is it important?

1074

Can we update views in sql?

990

How do you select unique values in sql?

1049

What is dml with example?

1156

What is a clob in sql?

1066

What language is oracle sql developer?

1072

What do you mean by “trigger” in sql?

1131

what is a constraint? : Sql dba

1234

What is an invalid partition table?

1068

What is the use of procedures?

1017

Explain the types of joins in sql?

1076

How many triggers can be applied to a table?

1127

How do you write an index?

1008