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

List out the three types of page locks that can be held.

1149

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

1278

What is load replace in db2?

994

How can you classify the locks in db2?

1089

What is a bind card?

1217

What is the physical storage length of the data types date, time, and timestamp?

1090

What is the syntax for creating a table in the db2 database?

1108

When do you specify the isolation level?

1032

What are foreign keys in db2?

1106

what are bind concepts in db2 cobol?

1093

How do I add a column to a table in db2?

1104

What is the purpose of using commit?

1099

What is scrollable cursor in db2?

1055

What is db2 bind?

1082

What is netezza database?

1028