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 do you understand by pl/sql packages?

1103

what is sql in mysql? : Sql dba

1237

Where not exists in sql?

1031

How can get second highest salary in sql?

1025

What is sqlservr exe?

1028

How do you write an inner join query?

986

What is the need of a partition key?

1026

Explain the order of sql statement execution?

1087

What is the max nvarchar size?

1027

What is varray in pl sql?

1120

Which data dictionary views have the information on the triggers that are available in the database?

1296

What sql does db2 use?

1028

Explain the uses of a database trigger?

1086

What is minus?

1051

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

1011