select a2.* from (select rownum r,a1.* from a a1)a2 where a2.r=&An

how u can find the n row from a table?

Question Posted / manoj gogoi

Answer Posted / manoj gogoi

select a2.*
from
(select rownum r,a1.* from a a1)a2
where a2.r=&Any_Row_U_Want

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is sql rowcount?

1033

What do you mean by stored procedures?

1017

What trigger means?

997

What is bind reference and how can it be created?

1025

What is the difference between the conventional and direct path loader? : aql loader

1157

Do we need to create index on primary key?

931

What are all the different types of indexes?

1153

What is record in pl sql?

1090

How do we accept inputs from user during runtime?

1071

What pl/sql package consists of?

1090

What is a schema? How is it useful in sql servers?

1125

What is a join query?

970

What is delimiter sql?

1014

What is application trigger?

1003

What is dense_rank in sql?

993