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
27762 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 deadlock in db2?

1124

What is bind package and plan in db2?

1111

What is package in db2 mainframe?

1041

Explain the contention situations caused by locks?

1147

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

1160

Define predicate?

1204

What is schema in db2?

1084

What is a Foreign Key?

1145

What is the function of logging in the db2 database?

1175

What is the difference between db2 and oracle?

1182

How to run db2 command in windows?

1249

What is db2 bind process?

1292

What is explain plan in db2?

1052

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2268

Can we insert update delete in view?

1032