select 100 records from million records ?

Question Posted / visu.kanchamreddy

2 Answers
7905 Views
Verizon, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

select 100 records from million records ?..

Answer / prachi

SELECT * FROM TABLENAME
FETCH FIRST 100 ROWS ONLY;

This will fetch 1st 100 records

Is This Answer Correct ?

20 Yes

0 No

select 100 records from million records ?..

Answer / ankit.:-)

if u want to fetch first 100 go for

select * from tablename fetch only 100 rows;

this will select only 100

Is This Answer Correct ?

5 Yes

5 No

Post New Answer

More DB2 Interview Questions

What is precompiler in db2?

0 Answers

What are the prerogatives?

0 Answers

How to know the primary key of a table without defining the primary key in the table?

5 Answers Satyam,

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers Cap Gemini,

What is a collection in db2?

0 Answers

What do you do to keep the cursor from closing after a commit?

1 Answers

How many databases can be created inside an instance in db2 ?

0 Answers MCN Solutions,

what is REORG? what is the use?

4 Answers

What is ibm db2 used for?

0 Answers

Mention data types used in db2 ?

0 Answers

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!

17 Answers KNIT, Tech Mahindra,

What are the contents of a DCLGEN?

4 Answers MetLife,

For more DB2 Interview Questions Click Here