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 dml and ddl?

1011

How do I run a program in pl sql?

1055

What is mdf ldf and ndf?

1060

How do you run a query?

1051

Write a sql query to find the names of employees that begin with ‘a’?

1058

How do you update sql?

1039

what are all different types of collation sensitivity? : Sql dba

1031

what are the types of join and explain each? : Sql dba

1088

What are the methods of filing?

994

what are the differences among rownum, rank and dense_rank? : Sql dba

1087

What is group by in sql?

1128

How do I run pl sql in sql developer?

1176

What is duration in sql profiler trace?

1140

How do you remove duplicates without using distinct in sql?

1019

Is oracel sql developer written in java?

1169