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

how to create a new table by selecting rows from another table in mysql? : Sql dba

564

explain normalization concept? : Sql dba

592

Explain the uses of control file.

618

differentiate between float and double. : Sql dba

563

What is compound trigger?

563

Explain ddl statements in pl/sql?

580

What is difference between ms sql and mysql?

479

Is pl sql still used?

512

What does cursor do in sql?

521

What is forward declaration in pl sql?

590

How to add, remove, modify users using sql?

563

What is the default isolation level in sql server? : Transact sql

570

What is the difference between jpql and sql?

555

What is the max nvarchar size?

525

how to enter characters as hex numbers? : Sql dba

574