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 tables and fields in the database?

1104

what are the 'mysql' command line options? : Sql dba

1070

Are stored procedures compiled?

915

What is join view in sql?

944

How do you pronounce sql?

1005

What does data normalization mean?

949

What is Collation Sensitivity ? What are the various type ?

950

What is difference between mysql and postgresql?

1146

What are the operators in sql?

1025

Write a sql query to get the third highest salary of an employee from employee_table?

1067

What is relationship? How many types of relationship are there?

1171

how many tables will create when we create table, what are they? : Sql dba

1069

Is microsoft sql free?

1095

What is a join query?

954

describe mysql connection using mysql binary. : Sql dba

1061