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 the non-standard sql commands supported by 'mysql'? : Sql dba

569

Why trigger is used in sql?

523

explain access control lists. : Sql dba

549

How many types of relationship are there?

543

Is nosql faster than sql?

534

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

574

where are cookies actually stored on the hard disk? : Sql dba

574

what is the different between now() and current_date()? : Sql dba

519

Name three sql operations that perform a sort.

580

What is the current version of sql?

528

What is the difference between subquery and correlated query?

528

What is difference between function and trigger?

538

How do I save a sql query?

540

What are aggregate functions in sql?

619

What are the three pl sql block types?

567