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 sql*loader and what is it used for?

1217

Which data type is a composite type?

1035

How do I find duplicates in two columns?

1261

Explain scalar functions in sql?

1103

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1203

Explain the order of sql statement execution?

1087

Can sql function call stored procedure?

1070

What are the types pl/sql code blocks?

1193

How do I view tables in sql developer?

1008

Can we join tables without foreign key?

1005

What are keys in sql?

1040

What are tables and fields?

1084

Does db2 use sql?

1009

What is data profiling in sql?

1133

What are the indexing methods?

1096