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 non-clustered index in sql?

753

How can we implement rollback or commit statement in a trigger?

787

What are different types of sql?

755

How do I quit sql?

685

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

792

What do you mean by stored procedures?

732

What is the difference between count 1 and count (*) in a sql query?

667

what are the limitations of identity column? : Transact sql

822

What is rownum and rowid?

760

What are the events on which a database trigger can be based?

817

Give the order of sql select?

831

How do you update a value in sql?

717

Mention what is the use of function "module procedure" in pl/sql?

784

how do you know the version of your mysql server? : Sql dba

690

How delete all data from all tables in sql?

687