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 fetch first 100 rows in db2

What does db2 blu stand for?

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

What is nvl in db2?

What's the difference between DB2 active log and archive log? Thanks a lot...

What information is held in SYSIBM.SYSCOPY?

What is an alias and how does it differ from a synonym?

What action db2 takes when a program aborts in the middle of a transaction?

What is the syntax required for the creation of a cursor?

how to execute qcmdexc in rpgle?plz write code also?

What are the Isolation levels possible ?

For more DB2 Interview Questions Click Here