your qestion is not clear ??? first 100 rows or 100 rows any where ?? t

how can we retrieve the 100 records of the file ?

Question Posted / lu

2 Answers
8430 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / lu

your qestion is not clear ??? first 100 rows or 100 rows
any where ??
this is FIRST 100 row :
SELECT * FROM TABLE
FETCH FIRST 100 ROWS ONLY
now if u want retrieve 100 rows in any table, you have to
create a counter ....

Is This Answer Correct ?

10 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is check constraint in db2?

1095

What is ibm db2 used for?

1087

What types of tables are there in the db2 database?

1061

What is null indicator in cobol db2?

1070

How to connect to db2 database from windows command line?

1069

What is db2 catalog database?

1050

What is dclgen in db2?

1153

What is sqlca’s maximum length?

1197

What is dbrm in db2 database?

1125

Discuss about db2 bind?

1103

What is the difference between spufi and qmf?

1137

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1202

What is phantom read in db2?

1166

What is multi row fetch in db2?

1055

What does runstats do in db2?

1126