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

select 100 records from million records ?

Question Posted / ankit.:-)

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

Please Help Members By Posting Answers For Below Questions

What is the use of commit in db2?

1144

What is the physical storage length of date data type?

1308

What is the latest version of ibm db2?

1338

How to rename a table in DB2 ?

1146

List down the data types in the db2 database.

1183

What is difference between rollback and commit?

1205

What is view db2?

1131

What is cursor with hold option in db2?

1138

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1290

Which isolation level provides highest data integrity?

1189

What is sqlca’s maximum length?

1250

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

1145

is it compulsory commitment control in journal?

2521

How do I delete a column in db2?

1155

How to check table size in db2 sap?

1096