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
26454 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?

999

What is declare cursor?

1043

What is db2 look?

970

What is db2 command?

963

How is the value function used?

1080

What is a buffer in memory?

1005

What does db2 blu stand for?

1100

Which components manage deadlocks in db2?

1016

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1041

What is the physical storage length of timestamp data type?

1025

Explain about mirror activator disk mirroring?

957

How to view db2 table structure?

960

What is the use of value function?

1074

How does coalesce work?

958

What is sqlca’s maximum length?

1102