SELECT * FROM TABLE FETCH FIRST 100 ROWS ONLY

how to fetch first 100 rows in db2

Question Posted / sesha

Answer Posted / sesha

SELECT * FROM TABLE
FETCH FIRST 100 ROWS
ONLY

Is This Answer Correct ?

34 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How can you classify the locks in db2?

1089

What do you mean by between and in? Is between inclusive of specified range values?

1090

How do I change the column size in db2?

1151

How do I copy a table in db2?

996

What are packages in db2?

1019

Which component is used to execute the sql statements?

1094

What is release/acquire in bind?

1102

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1077

What is catalog database in db2?

1160

What are iseries servers?

1072

Define declaration generator (dclgen).

1112

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1274

Name the lockable units in DB2?

1127

Which component is responsible for processing sql statements and selecting access paths?

1127

What is database reorganization?

1125