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
18501 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

Explain what is table in a database?

1069

What is a full join sql?

1066

What is plpgsql language?

1071

Give the order of sql select?

1146

Can we join same table in sql?

1036

What are schema-level triggers?

1111

Explain what is a database?

1095

what is not null constraint? : Sql dba

1047

Is join an inner join?

982

What is your daily office routine?

2279

How can you know that statistics should be updated?

1087

What is replication id?

944

What is a sql*loader control file?

1277

What is the process of debugging?

1080

What is constant in pl sql?

1035