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
27021 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 the physical storage length of the data types: date, time, timestamp in the db2 database?

1135

How do I copy a table in db2?

988

Can you use max on a char column?

1072

Is db2 a mainframe database?

974

What is db2 connect?

1048

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1064

Explain various types of locks in db2?

1122

Which component is responsible for db2 startup and shutdown?

1014

What is runstats utility in db2?

998

How do you pull up a query which was previously saved in qmf?

1134

What is db2 optimizer?

1214

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

1030

Explain the contention situations caused by locks?

1050

What is the role of the data page in the db2 database?

1009

What is the difference between nvl and coalesce?

1048