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

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

What is the picture clause of null indicator variable?

What is COPY PENDING status?

Which transaction use a command thread ?

Explain the use of the WHERE clause?

What is a DB2 plan?

What does reorg do in db2?

What is the usage of open cursor command?

What are the disadvantages of PAGE level lock?

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

What is the connection string to connect to the DB2 Database ?

For more DB2 Interview Questions Click Here