how to fetch first 100 rows in db2

Answer Posted / jagan

select top 100 from tableName;

Is This Answer Correct ?    1 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you find the maximum value in a column in db2?

648


What is the latest version of ibm db2?

735


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1594


What is bind in db2?

604


How to resolve deadlock issue

17966






How and when does the db2 enforces the unique key?

613


What is db2 catalog database?

582


What is the physical storage length of the data types date, time, and timestamp?

604


What is an instance in db2?

563


What are concurrency issues?

626


What are db2 tables?

645


What is drop table?

582


What do you mean by storage group (stogroup)?

581


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

658


What is the use of dclgen in db2?

588