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

How to create a table using embedded sql?

What are some characteristics of columns that benefit from indexes?

difference between group clause and order clause

What is package versioning? Please give an example.

Explain what are the various isolation levels possible?

Why use RUNSTAT Utility?

How to find the maximum value in a column in the db2 database?

Explain the contention situations caused by locks?

How do I copy a table in db2?

What is read-only cursor?

Can you tell me how can you find out the # of rows updated after an update statement?

What does db2 blu stand for?

For more DB2 Interview Questions Click Here