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
27222 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 dbrm library?

1064

What is rct?

1237

When do you specify the isolation level?

1034

What is the use of with ur in db2?

1058

What is cobol db2?

1003

What is db2 bind?

1085

What is the difference between db2 and oracle?

1133

What is load utility in db2?

1181

Is it possible using max on a char column?

1141

What are db2 objects?

1049

What is database alias db2?

1129

What is check constraint in db2?

1091

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3581

Define data page.

1072

What does db2 stand for?

1027