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 clustering index in the db2 database?

1001

What are the full forms of spufi and dclgen and why are they used?

1087

List out the buffer pools in db2

1073

Explain about dbrm.

1045

What is dbrm in db2 database?

1114

What is cobol db2?

999

What is the role of schema in the db2 database?

1273

What are the contents of dclgen?

1112

What is dbrm library?

1051

How to find primary key of a table in db2?

1063

What is the maximum length of sqlca?

1525

How to fetch the last row from the table in SQL (db2)?

1652

Which isolation level provides maximum concurrency?

1151

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

1090

Explain about rct.

1086