select * from emp where rowid in(select rowid from emp where rownum<=&

how to retrieve last tree records from table?
select *from emp where rownum > (select count(*)-3 from
emp);
i am using this query to get last three records from table
but its not giving any output, so please tell me what is the
error in this query.

Question Posted / pavithra

16 Answers
23657 Views
I also Faced
E-Mail Answers

Answer Posted / pavithra

select * from emp where rowid in(select rowid from emp
where rownum<=&upto minus select rowid from emp where
rownum<&start)

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1089

Which are the different types of indexes in sql?

1053

What is the use of index in sql?

1008

What are the triggers associated with image items?

1034

What is a design view?

920

What is online transaction processing (oltp)?

1015

Why do we use joins in sql?

968

What is normalisation in sql?

1049

What is a temp table?

1019

Is hadoop a nosql?

992

What is anonymous block in sql?

1114

what are the advantages of mysql in comparison to oracle? : Sql dba

993

explain access control lists. : Sql dba

990

what is the difference between primary key and unique key? : Sql dba

1028

What is the life of an sql statement?

1014