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

Can we use joins in subquery?

1139

Is keyword pl sql?

959

Which is better join or inner query?

1014

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

1001

How to rename a column in the output of sql query?

1061

What is sqlerrm?

918

How many types of tables are there?

929

Why procedure is used in sql?

1022

What are the parts of a basic sql query?

954

How do I make sql search faster?

980

Explain the difference between rename and alias?

1000

What packages are available to pl/sql developers?

1025

What is varray in pl sql?

1054

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1039

Can you upgrade sql express to full sql?

1043