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

Which is better stored procedure or query?

959

What is sql injection owasp?

1070

What is the difference between database trigger and stored procedure?

1080

What is pivot query?

1082

Can you have more than one trigger on a table?

1003

What is a constraint? Tell me about its various levels.

1164

what is sub-query? : Transact sql

1108

Why truncate is used in sql?

1010

Which is faster joins or subqueries?

991

how to use in conditions? : Sql dba

1015

Can we insert in view in sql?

1065

How show all rows in sql?

1017

What is varchar example?

1038

What are the operators used in select statements?

1058

Is delete faster than truncate?

1006