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

List down the data types in the db2 database.

1097

What is database alias db2?

1105

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3140

What is db2 look?

1007

What is the use of reorg in db2?

1068

How do you select a row using indexes in db2?

1119

What types of tables are there in the db2 database?

1038

What is cursor with hold option in db2?

1052

How is a typical db2 batch pgm executed?

1159

What is a buffer in memory?

1043

Can we delete records from view?

952

What is view db2?

1051

Which command is used to connect to a database in DB2 ? Give the Syntax.

1085

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1052

What does a deadlock mean in DB2?

1151