How about combingin two queries with set operator EXCEPT, if you have que

I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys)
Anyone please reply ASAP!

Question Posted / mvramesh

17 Answers
27038 Views
KNIT, Tech Mahindra, I also Faced
E-Mail Answers

Answer Posted / mvramesh

How about combingin two queries with set operator EXCEPT,
if you have query A EXCEPT query B, the result would be A-B.

Select * from table A fetch first 200 rows only
Union except
Select * from table A fetch first 100 rows only

Is This Answer Correct ?

5 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is database manager in db2?

1001

What is concurrency?

1209

How do I connect my db2 database to ibm?

1030

What is a plan and package in db2?

1086

what is db2 restart?

2134

Explain about cursor stability?

1024

Explain about rct in db2?

1091

What is schema in db2?

1007

How can record locking be achieved in those DB2 versions which do not support it?

1060

What is host variable?

1036

What is the use of value function?

1128

Why do we bind in db2?

1195

What is scrollable cursor in db2?

1042

Who uses db2?

1024

How many databases are there?

1036