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

explain advantages of myisam over innodb? : Sql dba

1017

How do you write a subquery?

968

Is a table valued function object?

962

how do you tune the slow running queries in oracle db , explain the methodology

2072

Which join condition can be specified using on clause?

901

What is the basic form of sql query?

881

Are subqueries faster than joins?

955

What do you understand by pl/sql records?

961

How many sql commands are there?

1073

Explain autonomous transaction.

1095

what is a database lock ? : Sql dba

1093

What are the advantages of stored procedure?

947

What is the primary use of normalization?

944

What is difference between hql and native sql?

1093

what are numeric data types? : Sql dba

1004