try this one..... select * from emp where count(*)

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

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

Answer Posted / kumar

try this one.....

select * from emp where count(*) > 100 and count (*) < 200;

Is This Answer Correct ?

3 Yes

16 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is image copy in db2?

1072

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2387

What is the use of runstats in db2?

1179

What is lock escalation in db2?

1083

How do I add a column to a table in db2?

1158

Is db2 a programming language?

1101

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2223

What is the default page size of buffer pools?

1171

What does reorg do in db2?

1074

What is the syntax for seeing the columns and data types of a table in the db2 database?

1237

How to take backup of table in db2?

1122

How many databases are there?

1112

what is a corelated subquerry?

1170

Can you use max on a char column?

1144

How does cobol compile db2 program?

1130