select * from emp where rownum<151 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 / sravan

Answer Posted / sravan

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

Is This Answer Correct ?

13 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What is normalisation in sql?

1101

what is the syntax used for partition in tsql? : Transact sql

1061

What is dbo in sql?

1020

What is sqlca in db2?

1038

How does postgresql compare to oracle/db2/ms sql server/informix?

1094

Why do we go for stored procedures?

1127

What can sql server reporting services do?

1166

How to Declare Fixed Length String Value In PL SQL

1208

How many scalar data types are supported in pl/sql?

1106

What is the difference between instead of trigger and after trigger?

1070

What are the key differences between SQL and PL SQL?

1286

Is not equal in sql?

1064

What is varchar sql?

1207

What do you mean by stored procedures?

1071

What does plv msg allows you to do?

1179