select * from(select * from emp order by rowid desc)where rownum=5;

how to find 5th row ?

Question Posted / krish

Answer Posted / krish

select * from(select * from emp order by rowid desc)where
rownum=5;

Is This Answer Correct ?

1 Yes

7 No

Please Help Members By Posting Answers For Below Questions

how can we repair a mysql table? : Sql dba

988

Can a table contain multiple foreign key’s?

1003

How do you truncate?

915

how do you login to mysql using unix shell? : Sql dba

1086

What is mdf ldf and ndf?

1005

What is user defined functions?

990

what is uncommittable transactions? : Transact sql

1000

What is sql profiling in oracle?

1068

List the various privileges that a user can grant to another user?

1047

In a distributed database system, can we execute two queries simultaneously?

1097

What are the disadvantages of not performing database normalization?

1168

What type of database is cloud sql?

1108

What is the difference between microsoft access and sql?

1029

What schema means?

893

How can you know that statistics should be updated?

1079