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

can we view the access paths created by dbrm ? how ? thx

6224

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

3778

What is phantom read in db2?

629

What is a bind in db2?

585

Define db2 and its databases?

612

What is scrollable cursor in db2?

573

What is meant by explain?

652

How to create backup table in db2?

631

Why do we use cursor?

583

How to compare data between two tables in db2?

652

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1926

What is bind in db2?

595

How is a typical db2 batch pgm executed?

630

How do I start db2 in windows?

551

What is blu acceleration in db2?

594