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
What are the popular database management systems in the it industry?
What is varchar example?
How to disable a trigger name update_salary?
What are the steps for performance tuning.
Why is nosql good?
Explain the savepoint statement.
What is dml with example?
What is set serveroutput on?
Can we join two tables without common column?
How do sql triggers work?
Explain the uses of database trigger.
Who developed sql?
How to take user input in pl sql?
List the different type of joins?
How do I upgrade sql?