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 is trigger explain it?

1016

What is view explain with example?

930

Is full outer join same as cross join?

969

What is posting?

1039

How can we solve sql error: ora-00904: invalid identifier?

1246

Explain the purpose of %type and %rowtype data types with the example?

994

What are the 3 types of behavioral triggers?

1253

What is sqlca in powerbuilder?

1015

What is the use of function in sql?

1094

What is form and report?

986

What is aggregate function in sql?

1037

What are the two different parts of the pl/sql packages?

1087

Is a secondary key the same as a foreign key?

1037

explain commit and rollback in mysql : sql dba

1016

How many types of keys are there in sql?

1038