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 variables in pl sql?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is difference between my sql and sql?
How do I tune a sql query?
Why is the cursor important?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
How many triggers can be applied on a table?
List the different type of joins?
Can a primary key be a foreign key?
What is meaning of <> in sql?
what is an index? : Sql dba
How do you rename a table in sql?
What is a left join?
What is the mutating table and constraining table?
how to add a new column to an existing table in mysql? : Sql dba