select * from <Table name> where <condition> condition:- usi

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 / om prakash yadav

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

Answer Posted / om prakash yadav

select * from <Table name> where <condition>

condition:- using BETWEEN

eq:-

select * from emp where empno between( 100 to 200).

Is This Answer Correct ?

11 Yes

17 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the purpose of using commit?

1100

What db2 400?

1195

What is coalesce in db2?

1136

Is it possible using max on a char column?

1141

what is a corelated subquerry?

1122

What is a Foreign Key?

1100

What is lock escalation in db2?

1033

What's The Error Code For Unique Index Voilation?

1240

can all users have the privilage to use the sql statement select * (dml)?

1174

What is the maximum length of sqlca?

1529

How can deadlocks be resolved?

938

What are the uses of db2 optimizer?

1297

What is sqlca?

1079

is it compulsory commitment control in journal?

2479

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

1032