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 do you rename a table in sql?

1186

How do you define a foreign key?

1067

What does dml mean?

1043

What is basic structure of pl sql?

1132

How to move files from one directory to another in pl sql?

1254

What are triggers and its uses?

1096

What is oracle sql developer?

1119

What is a sql trace file?

1085

Who developed sql?

1101

What is the usage of distinct keyword?

1116

What is clause?

1230

define join and explain different type of joins? : Sql dba

1002

What is the difference between an inner and outer join?

1062

how to present a past time in hours, minutes and seconds? : Sql dba

1072

Is primary key always clustered index?

1067