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

Is oracle and sql same?

1020

Which data dictionary views have the information on the triggers that are available in the database?

1246

What is a call statement? Explain with an example.

1021

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1199

Is clustered index a primary key?

955

Are subqueries better than joins?

981

What is Materialized View? In What Scenario we Use Materialized View?

9532

What is cursor in pl sql with examples?

1041

What are aggregate and scalar functions?

1032

what are the differences between char and nchar? : Sql dba

1120

What are variables in pl sql?

1174

How to display the current date in sql?

1086

Why do we use procedures in sql?

1093

What is the source code of a program?

1077

What is microsoft t sql?

951