SELECT * FROM TABLE WHERE COUNT(*) = 100;

I have 1000 rows in a db2 table.I want to update first 100
records,How do I do it?

Question Posted / sireesha

Answer Posted / sireesha

Is This Answer Correct ?

1 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What is the role of schema in the db2 database?

649

Mention the definition of cobol in varchar field.

687

What is a system catalog table in db2?

586

My sql statement select avg(salary) from emp yields inaccurate results. Why?

639

What is cloudant database?

641

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

657

How to check sequence on a table in db2?

598

What is the difference between spufi and qmf?

637

What is copy pending status in db2?

636

What does runstats do in db2?

607

What are the contents of dclgen?

652

What's The Percentage Free Space ?

768

What types of tables are there in the db2 database?

550

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

1632

Before you give the explain statement, what are the prerogatives?

579