display records from 5 to 9 using rowid or rownum
Answer Posted / vinay shankar
select * from emp
where rownum <=9
minus
select * from emp
where rownum <5
| Is This Answer Correct ? | 31 Yes | 6 No |
Post New Answer View All Answers
What is trigger explain it?
What is view explain with example?
Is full outer join same as cross join?
What is posting?
How can we solve sql error: ora-00904: invalid identifier?
Explain the purpose of %type and %rowtype data types with the example?
What are the 3 types of behavioral triggers?
What is sqlca in powerbuilder?
What is the use of function in sql?
What is form and report?
What is aggregate function in sql?
What are the two different parts of the pl/sql packages?
Is a secondary key the same as a foreign key?
explain commit and rollback in mysql : sql dba
How many types of keys are there in sql?