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 a delimiter in sas?

1035

Is sqlexception checked or unchecked?

950

What is a primary key called that is made up of more than one field?

1331

Explain sql data types?

1077

What is trigger in sql? Explain

976

What is raw datatype in sql?

1029

How do I kill a query in postgresql?

1074

what is the difference between truncate and delete statement? : Transact sql

1045

What is data definition language?

1081

how to write date and time literals? : Sql dba

946

Explain locks? : Transact sql

987

What is a nested table in word?

946

What is an index in sql with example?

959

what are local and global variables and their differences? : Sql dba

1055

If a cursor is open, how can we find in a pl/sql block?

1149