if u want to fetch first 100 go for select * from tablename fetch only 1

select 100 records from million records ?

Question Posted / ankit.:-)

Answer Posted / ankit.:-)

if u want to fetch first 100 go for

select * from tablename fetch only 100 rows;

this will select only 100

Is This Answer Correct ?

5 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What are iseries servers?

568

Mention the different locking levels that are available in db2.

647

What are the bind parameters ibm db2?

624

Which command is used to remove all rows from a table?

553

How connect db2 database to datastage?

765

Which are the db2 tools to protect integrity of the database?

692

What is iseries database?

597

What is multi row fetch in db2?

611

What is dclgen (declaration generator)?

604

How and when does the db2 enforces the unique key?

616

What are the different types of base tables?

587

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10778

What is isolation level in db2?

577

What does db2 stand for?

598

What is clone table?

592