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 makes a good primary key?

1093

Is a foreign key always unique?

981

How to use sql*plus built-in timers?

1257

Is oracle and sql same?

1074

What is hibernate and its relation to sql?

1167

What are dml commands?

1070

How to use boolean type in select statement?

1135

what is foreign key? : Sql dba

1105

How many clustered indexes can you have?

1037

Where the sql database files are stored?

1072

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

1017

Why are aggregate functions called so?

1012

Does mysql_real_escape_string prevent sql injection?

993

What is the maximum database size for sql express?

1071

What is the limitation on the block size of pl/sql?

1034