if u want to fetch first 100 go for select * from tablename fetch only 1

select 100 records from million records ?

Question Posted / ankit.:-)

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

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

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

1039

What does runstats do in db2?

1022

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1091

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8132

What db2 400?

1101

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2665

How can you classify the locks in db2?

1031

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1029

Can we insert update delete in view?

908

What are the bind parameters ibm db2?

988

What is a db2 tablespace?

996

What is the use of predicate?

982

What is multi row fetch in db2?

983

How to resolve deadlock issue

19858

What is copy pending status in db2?

1067