display records from 5 to 9 using rowid or rownum

Answer Posted / chiru

select * from (select rownum r ,a.* from emp a ) where r between 5 and 9

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the popular database management systems in the it industry?

643


What is varchar example?

662


How to disable a trigger name update_salary?

788


What are the steps for performance tuning.

933


Why is nosql good?

695






Explain the savepoint statement.

691


What is dml with example?

605


What is set serveroutput on?

742


Can we join two tables without common column?

594


How do sql triggers work?

645


Explain the uses of database trigger.

760


Who developed sql?

670


How to take user input in pl sql?

811


List the different type of joins?

672


How do I upgrade sql?

647