how to fetch first 100 rows in db2

Question Posted / guest

Answers were Sorted based on User's Feedback

how to fetch first 100 rows in db2..

Answer / sesha

SELECT * FROM TABLE
FETCH FIRST 100 ROWS
ONLY

Is This Answer Correct ?

34 Yes

2 No

how to fetch first 100 rows in db2..

Answer / jagan

select top 100 from tableName;

Is This Answer Correct ?

1 Yes

12 No

More DB2 Interview Questions

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

What if we fail to give values in columns declared as NOT NULL ?

How to create backup table in db2?

How to rename a table in DB2 ?

What is a Cartesian product?

What is a db2 collection?

What is access path in db2?

What are the various locking levels available?

List down the types of triggers in the db2 database?

When do you use the IMAGECOPY?

how to resolve -811 sqlcode .give clear explaination

What is -904 sql code? How to resolve it?

For more DB2 Interview Questions Click Here