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
27763 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 are concurrency issues?

1176

Is it possible using max on a char column?

1196

Mention data types used in db2 ?

1205

How does coalesce work?

1079

What action db2 takes when a program aborts in the middle of a transaction?

1199

What is a db2 schema?

1300

What is precompiler in db2?

1081

What is cobol db2?

1050

How do I optimize a query in db2?

1155

What is the maximum No of rows per page?

1121

How can you count the number of rows from a table tab?

1140

How and when does the db2 enforces the unique key?

1144

How can you find out the # of rows updated after an update statement?

1158

what is utility for parm lib

2424

i want to maintain uniqueness on pdf without make lf??????????

2209