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 cold data?

507

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

524

What is a unique constraint?

610

Explain character-manipulation functions?

636

How do I kill a query in postgresql?

554

What is a trigger in sql?

642

Is microsoft sql free?

604

How can I delete duplicate rows?

564

What is the use of sql trace?

481

What is the difference between unique and primary key constraints?

588

Which version of sql do I have?

564

How many sql statements are used?

570

What is full form of rtm?

535

What is the max nvarchar size?

521

Why stored procedure is better than query?

511