select * from emp where rownum <=9 minus select * from emp where

display records from 5 to 9 using rowid or rownum

Question Posted / vinay shankar

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

Please Help Members By Posting Answers For Below Questions

What are variables in pl sql?

1094

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1116

What is difference between my sql and sql?

997

How do I tune a sql query?

935

Why is the cursor important?

979

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

971

How many triggers can be applied on a table?

882

List the different type of joins?

1003

Can a primary key be a foreign key?

970

What is meaning of <> in sql?

1023

what is an index? : Sql dba

933

How do you rename a table in sql?

1034

What is a left join?

890

What is the mutating table and constraining table?

969

how to add a new column to an existing table in mysql? : Sql dba

1003