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

Is sql a oracle?

916

How much does sql cost?

930

What is a nested table in word?

911

Can we insert in view in sql?

1004

What is nosql example?

971

Can we rollback truncate?

947

What is the difference between left and left outer join?

894

What is pl sql package?

993

What can I use instead of union in sql?

905

Is sql dba a good career? : SQL DBA

943

how many values can the set function of mysql take? : Sql dba

935

What are local and global variables and their differences?

1047

Explain scalar functions in sql?

1019

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1003

What does select * from mean in sql?

3073