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
26453 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

How to check sequence on a table in db2?

994

What is the reason behind not using select * in embedded sql programs?

1044

Where do you specify them?

1165

Explain package in db2 and its advantages?

1134

Mention data types used in db2 ?

1105

Which components manage deadlocks in db2?

1016

What is the physical storage length of the data types date, time, and timestamp?

1039

Which component is responsible for processing sql statements and selecting access paths?

1070

What is the use of predicate?

983

List some fields from sqlca?

1001

What is temporal table in db2?

988

Mention the downsides of page level lock.

1112

What is dbrm? What it contains?

1109

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3145

What is iseries database?

990