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 the purpose of primary key?

541

Can we change the table name in sql?

541

what is the difference between delete and truncate statement in sql? : Sql dba

561

What is sql not null constraint?

616

What is difference between hql and native sql?

591

What is parallel hint?

758

Differentiate between syntax and runtime errors.

648

What is the difference between truncate and drop statements?

583

How do I write a cron which will run a sql query and mail the results to agroup?

533

What is the purpose of normalization?

547

What is the difference between jpql and sql?

565

Explain constraints in sql?

579

What is the use of function in sql?

549

What is nosql db?

554

how to create a new view in mysql? : Sql dba

508