SELECT * FROM TCB732D.AR_AR WHERE NUM_SEQ_AR IN( SELECT NUM

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 / rajeshkumar

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

Answer Posted / rajeshkumar

SELECT * FROM TCB732D.AR_AR WHERE NUM_SEQ_AR IN(
SELECT NUM_SEQ_AR FROM TCB732D.AR_AR ORDER BY NUM_SEQ_AR
FETCH FIRST 200 ROWS ONLY)
ORDER BY NUM_SEQ_AR FETCH FIRST 100 ROWS ONLY

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between bind and rebind in db2?

1389

What is collection in db2 bind?

955

what is db2 restart?

2097

What is syscat in db2?

949

What is bind package and plan in db2?

1004

What is the default page size of buffer pools?

1065

What is a dbrm in db2?

965

What is copy pending status in db2?

1067

What is the difference between oracle and db2?

1028

How to restart a DB2 program?

1823

Which command is used to connect to a database in DB2 ? Give the Syntax.

1028

Can we insert update delete in view?

908

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2778

What is meant by explain?

1058

What is db2 connect?

1006