SELECT * FROM ( SELECT ROWNUM R , A.* FROM TABLE

how u can find the n row from a table?

Question Posted / kris17.danger

Answer Posted / kris17.danger

SELECT * FROM ( SELECT ROWNUM R , A.* FROM TABLE_NAME A )
WHERE R=N;

Herer N is the number of row which need to be find.

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain constraints in sql?

575

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

542

What do you understand by pl/sql records?

535

What is the life of an sql statement?

527

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

623

What is sql catalog?

570

What's the difference between a primary key and a clustered index?

520

When is the update_statistics command used?

576

What are the different ways to optimize a sql query?

492

how to delete an existing column in a table? : Sql dba

555

what is a field in a database ? : Sql dba

547

How many sql commands are there?

677

Which sql statement is used to delete data from a database?

468

What steps server process has to take to execute an update statement?

514

What are database links used for?

595