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 a memo field?

898

Explain the the update statement in sql?

986

What is the maximum rows in csv?

856

What is a table partition?

1036

What is scope and visibility in PL/SQL?

1109

How global cursor can be declare with dynamic trigger ?

2145

What is difference between table and view?

974

what is the difference between truncate and delete statement? : Transact sql

1012

difference between anonymous blocks and sub-programs.

1077

Explain what is a database?

1033

how to use myisamchk to check or repair myisam tables? : Sql dba

910

Does truncate remove indexes?

966

how many columns can be used for creating index? : Sql dba

894

Explain the difference between sql and mysql.

1000

What are the different datatypes available in PL/SQL?

1025