select * from emp where rownum<151 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 / sravan

Answer Posted / sravan

select * from emp where rownum<151
minus(select * from emp where rownum<121)

Is This Answer Correct ?

13 Yes

14 No

Please Help Members By Posting Answers For Below Questions

Why do we create views in sql?

1053

What is java sql connection?

963

What is a stored procedure in sql with example?

1052

What are the different ddl commands in sql?

1064

explain the advantages and disadvantages of stored procedure? : Sql dba

956

Enlist some predefined exceptions?

993

What is trigger explain it?

959

What are the sql aggregate functions?

1065

What is cartesian join in sql?

1028

what is 'mysqlshow'? : Sql dba

973

What is the cause of mutating table error and how can we solve it?

992

How does pl sql work?

912

Is nosql faster than sql?

969

Is it mandatory for the primary key to be given a value when a new record is inserted?

1139

how can we submit a form without a submit button? : Sql dba

916