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 delete a row in sql?

926

What is difference between function and trigger?

969

What is the use of sql trace?

894

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

931

What is microsoft t sql?

880

Why procedure is used in sql?

969

Why cross join is used?

1020

What are functions in sql?

899

What is a parameter query?

1020

How do I enable sql encryption?

966

what is the difference between join and union? : Sql dba

1027

Can we insert data into view?

848

Cite the differences between execution of triggers and stored procedures?

1027

Explain isolation levels. : Transact sql

1014

What is the difference between Union and Union all. Which is faster.

1340