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

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1038

What are sql constraints?

1151

What is the difference between row level and statement level trigger?

976

How does postgresql compare to "nosql"?

998

Can I call a procedure inside a function?

967

How many types of privileges are available in sql?

1305

What do you mean by query optimization?

961

what is a view? : Sql dba

1036

what is cursor. write example of it. What are the attributes of cursor.

1330

What can sql server reporting services do?

1071

What are instead of triggers?

1013

When is the update_statistics command used?

1065

What are types of indexes in sql?

1029

Define concurrency control. : Transact sql

1127

What is the use of triggers?

997