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

What is alias in db2?

1047

What is package in db2 mainframe?

980

What is a bind card?

1212

what is the role of the cursor in db2?

1060

what is the responsibility of the construction superintendent

2138

How do I create a view in db2?

1015

List out the buffer pools in db2

1069

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

1026

What is netezza database?

1017

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2037

What is the syntax for FETCH in DB2 ?

1200

What is data manager?

1040

Explain the function done by data manager?

1273

What's The Percentage Free Space ?

1222

What is db2 instance?

1072