select * from emp where rownum<121 minus(select * from emp where rownum

A table has 150 records. How do you retrieve 100th row to
120th row from that table ?

Question Posted / laks

Answer Posted / laks

select * from emp where rownum<121
minus(select * from emp where rownum<101)

Is This Answer Correct ?

34 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is partition by in sql?

1068

Define implicit and explicit cursors.

1144

What kind of join is join?

966

How many types of cursors are available in pl/sql?

1109

What is sql profiling in oracle?

1062

Is sqlite thread safe?

1046

what are the performance and scalability characteristics of mysql? : Sql dba

996

What is the use of primary key?

1006

What's the difference between inner join and left join?

999

What is secondary key?

933

what are set operators in sql? : Sql dba

1052

Inline the values in PL/SQL, what does it mean.?

1226

What is the trigger in sql?

953

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1003

What is sql used for?

1124