select * from (select rownum rm,id from emp where rownum<=9) where rn &g

display records from 5 to 9 using rowid or rownum

Question Posted / hari

Answer Posted / hari

select * from (select rownum rm,id from emp where rownum<=9) where rn >=5)

Is This Answer Correct ?

4 Yes

5 No

Please Help Members By Posting Answers For Below Questions

what is a tablespace? : Sql dba

1049

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

1222

What program will open a mdb file?

960

What is data profiling in sql?

1072

What is indexing oracle sql?

1097

What is difference between cursor and trigger?

1070

Can we use ddl commands in pl sql?

1158

What is an invalid partition table?

1022

What are different methods to trace the pl/sql code?

1115

What makes a good primary key?

1032

Does sql*plus also have a pl/sql engine?

1076

Which are the different types of indexes in sql?

1055

What is a parameter query?

1075

If a cursor is open, how can we find in a pl/sql block?

1163

Does view store data in sql?

960