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

What is the difference between null value, zero, and blank space?

557

What is keys and its types?

546

Can one improve the performance of sql*loader? : aql loader

587

explain the delete statements in sql

583

What is pl sql collection?

527

What are the rules to be applied to nulls whilst doing comparisons?

756

What is lexical units in pl sql?

575

What is left join in sql?

585

how can we optimize or increase the speed of a mysql select query? : Sql dba

514

Can we use views in stored procedure?

515

What will you get by the cursor attribute sql%found?

540

What is denormalization in a database?

593

What is difference between nchar and nvarchar?

548

What does count (*) do in sql?

528

What is clause in sql?

586