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

Which component is used to execute the sql statements?

1053

What is reorg?

1071

What is query_cache_limit?

928

Name the lockable units in DB2?

1073

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

977

How to execute stored procedure in db2 command editor?

984

Explain packages.

1055

What is the maximum size of varchar data type in db2?

1066

What is the use of runstats in db2?

1022

How does a cursor work?

929

What is the maximum size of a char data type in db2?

964

What is the function of logging in the db2 database?

1069

What is role in db2?

1040

What is commit in db2?

996

How and when does the db2 enforces the unique key?

1028