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 to create backup table in db2?

644


Why select is not preferred in embedded sql programs?

714


How do you stop a db2 database in linux?

566


What is a trigger in the db2 database?

592


What are the contents of dclgen?

658






can we view the access paths created by dbrm ? how ? thx

6250


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

611


What is db2 catalog database?

582


what is a corelated subquerry?

658


What is the syntax for seeing the columns and data types of a table in the db2 database?

578


What is the difference between dbm cfg and db cfg file in db2 ?

1005


List out the buffer pools in db2

628


What kind of database is db2?

572


What is coalesce in db2?

682


What does db2 blu stand for?

660