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 are the benefits of stored procedures?
What is nested table in pl sql?
what is data integrity? : Sql dba
How many commands are there in sql?
What is crud stand for?
What is difference between function and trigger?
Is it possible to update views?
Is sql pronounced sequel or sql?
What is the basic structure of an sql?
What is number function in sql?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
How do you clear the screen in sql?
What are functions in sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What are the possible values for the boolean data field?