how to fetch first 100 rows in db2

Answer Posted / sesha

SELECT * FROM TABLE
FETCH FIRST 100 ROWS
ONLY

Is This Answer Correct ?    34 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define sqlca.

885


How to connect to db2 database from windows command line?

826


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2118


What is sqlca’s maximum length?

924


What does db2 plan contain?

789


What is a db2 tablespace?

812


What is the maximum length of sqlca?

1175


Where can you declare a cursor in a cobol-db2 program?

804


How would you find out the total number of rows in a db2 table?

812


How many databases can be created inside an instance in db2 ?

842


i want to maintain uniqueness on pdf without make lf??????????

1933


What is sqlca?

845


What are foreign keys in db2?

868


Define data page.

849


Is db2 relational database?

776