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 table space in db2?

795

What is the difference between cursor and select statement?

859

What is the role of data manager in the db2 database?

865

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

963

Explain about cursor stability?

798

What is page size in db2?

745

What is db2 optimizer?

1004

List down the data types in the db2 database.

820

What are db2 objects?

838

What is view db2?

851

what is utility for parm lib

2108

Is the primary key a clustered index?

844

How would the varchar column remarks defined?

855

What is consistency token in db2?

877

How many databases are there?

791