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

What is cascade in sql?

1017

Is sql a backend?

1075

What is file based approach?

1002

Why do we use function in pl sql?

1114

Does sql require a server?

1057

What is the use of procedures?

1020

What is graph sql?

1042

How many types of triggers are there in pl sql?

1122

what is meant by urlencode and urldocode? : Sql dba

1246

What is the need of a partition key?

1033

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1252

Write the alter statement to enable all the triggers on the t.students table.

1178

Is it mandatory for the primary key to be given a value when a new record is inserted?

1254

How do I create a sql script?

1144

Can we use views in stored procedure?

1088