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 know the version of your mysql server? : Sql dba

1004

Does inner join remove duplicates?

940

What is scalar and vector?

1002

What is rollback?

1112

Can we use ddl statements in stored procedure?

1152

What are the different parts of a package?

1115

How do you rank data in sql?

1003

How can I get the number of records affected by a stored procedure?

1065

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1001

Does db2 use sql?

945

what is the functionality of the function htmlentities? : Sql dba

960

How can one get sql*loader to commit only at the end of the load file? : aql loader

1059

How is indexing done in search engines?

982

Which sorts rows in sql?

1017

What is t sql used for?

1012