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 low level language?

1022

Define the select into statement.

1062

Why is sql*loader direct path so fast?

1108

How do you use a while loop in pl sql?

1015

Can ddl statements be used in pl/sql?

1146

What are local and global variables and their differences?

1093

How does sql developer connect to oracle database?

1006

Is pl sql a scripting language?

1035

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1171

Where is all the data on the internet stored?

1015

How do you update sql?

984

Why are sql stored procedures used?

1060

What is a left inner join?

1019

Can I learn sql in a week?

1082

What is a system versioned table?

992