display records from 5 to 9 using rowid or rownum

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cursor explain with example?

547


Is pl sql useful?

536


What is primary key secondary key alternate key candidate key?

536


What does the file extension accdb stand for?

545


what is the difference between inner and outer join? Explain with example. : Sql dba

544






What is linq to sql?

544


How do you optimize a query?

531


What is the non-clustered index in sql?

586


What is number function in sql?

524


How can I speed up sql query?

520


How does index help in query performance?

556


Is sql procedural language?

548


How do I create an index in word?

540


Why do we use procedures in pl sql?

516


What is the difference between clustered and non-clustered indexes?

599