select * from(select rownum r,column name,from table name) where r=&n;

how u can find the n row from a table?

Question Posted / a.brahmam

Answer Posted / a.brahmam

select * from(select rownum r,column name,from table name)
where r=&n;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is meant by nl2br()? : Sql dba

1107

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

1019

How do I use google cloud in sql?

1148

can a stored procedure call itself or recursive stored procedure? : Sql dba

1087

Why procedure is used in sql?

1087

Does asenumerable execute the query?

1097

what is 'mysqladmin' in mysql? : Sql dba

1076

What is difference between rank () row_number () and dense_rank () in sql?

1163

What is the difference between joins?

1094

what is the difference between char and varchar data types? : Sql dba

1174

Which command is used to delete a package?

1236

What is the use of pl/sql table?

1106

What are the key differences between SQL and PL SQL?

1286

What is exception? What are the types of exceptions?

1116

What are aggregate and scalar functions?

1090