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

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

Question Posted / swapna

Answer Posted / swapna

select * from emp where rownum<121
minus (select * from empwhere rownum<100);

Is This Answer Correct ?

11 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How do you bind variables in pl sql?

578

What is the execution plan in sql?

554

How to make a copy values from one column to another in sql?

572

Are stored procedures faster than dynamic sql?

528

Can we use ddl statements in stored procedure sql server?

512

What are different types of sql commands?

508

How to create an array in pl/sql?

580

Is grant a ddl statement?

449

What is a temporal table?

490

Explain the advantages and disadvantages of stored procedure?

642

What are % type and % rowtype?

570

Explain ttitle and btitle.

668

What is left join example?

499

What is time based sql injection?

486

Explain the working of foreign key?

542