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

What is sql key?

525

What is the difference between inner join and outer join?

532

Why triggers are used?

557

What is sqlcommand?

556

Does db2 use sql?

512

What is sqlite used for?

533

What is data modelling in sql?

523

What is the purpose of a secondary key?

513

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

554

Why is a primary key important?

547

What is procedure explain with program?

554

How many subqueries can be nested in a statement?

505

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

547

Why do we need pl sql?

550

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

579