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 it possible to create startup or shutdown trigger for on-schema?

1093

what are date and time data types in mysql? : Sql dba

1025

can a stored procedure call itself or recursive stored procedure? : Sql dba

1087

Is a table valued function object?

1076

How does sql*loader handles newline characters in a record? : aql loader

1094

What is bulk compiling in pl/sql.?

1193

What is a sql driver?

1041

How many postgresql users are there, worldwide?

1131

What is trigger in pl sql with examples?

1082

What is a schema? How is it useful in sql servers?

1178

Enlist the data types that can be used in pl/sql?

1112

Does db2 use sql?

1009

What are packages in pl sql and also explain its advantages?

1125

Can we rollback after truncate?

1073

What is string data type in sql?

1218