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
27012 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 dbrm in db2 database?

1089

Can we update view in db2?

983

What is the cobol picture clause of the db2 data types date, time, timestamp?

1040

What are types of indexes?

1037

What is universal database?

1052

What kind of database is db2?

1021

What is dbrm? What it contains?

1145

How can you do the explain of a dynamic sql statement?

1052

Before you give the explain statement, what are the prerogatives?

1010

What is a db2 cursor?

1032

What language is db2 written in?

1024

What is access path in db2?

965

How to compare data between two tables in db2?

1062

What is meant by dclgen?

1092

Why db2 is called db2?

1006