db2 "SELECT EmpNo FROM (SELECT EmpNo, dense

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

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

Answer Posted / saeed

db2 "SELECT EmpNo FROM (SELECT EmpNo, dense_rank() over
(order by EmpNo) RNo FROM office) xyz WHERE RNo >= 100 AND
RNo<=200 "

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is db2 and what is the use of db2 optimizer?

1071

What is the advantage in De-normalizing tables in DB2?

1189

How does a cursor work?

994

What does db2 stand for?

1037

Explain the contention situations caused by locks?

1081

Explain about open switch business continuity software?

1141

What os does db2 run on?

994

What is dbrm? What it contains?

1170

Where can you declare a cursor in a cobol-db2 program?

1085

What is the use of predicate?

1050

What do you mean by commit and rollback?

1051

Which command is used to remove all rows from a table?

1121

Explain about rct in db2?

1117

What is iseries database?

1058

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1245