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 the example of procedure?

912

What is pls integer?

1019

What is acid property in a database?

1020

Write a sql select query that only returns each name only once from a table?

997

Can we debug stored procedure?

1013

explain what is mysql? : Sql dba

1066

What is foreign key and example?

919

What is the difference between function, procedure and package in pl/sql?

1228

What is right join sql?

954

What is query execution plan in sql?

1174

What is a left join?

939

What is the difference between a procedure and a function?

1087

what is normalization? : Sql dba

1071

What problem one might face while writing log information to a data-base table in pl/sql?

1140

Which join is like an inner join?

1016