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

Does execute immediate commit?

1223

How do I quit sql?

964

What are the different types of joins in sql?

1797

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

982

What is the difference between union and union all command?

1094

What is inner join in sql?

1085

What are the various restrictions imposed on view in terms of dml?

967

Does oracle use sql?

933

What is the difference between a procedure and a function?

1119

Difference between truncate, delete and drop commands?

1083

Why is stored procedure faster than query?

964

What is cursor in pl sql with examples?

1035

What do you mean by query optimization?

1006

What is partition in sql query?

1002

what is the difference between cluster and non cluster index? : Sql dba

1029