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

4 Answers
15660 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / sireesha

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

Is This Answer Correct ?

1 Yes

9 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is explain in db2?

1012

What is the cobol picture clause of the db2 data types date, time, timestamp?

1057

What type of database is db2?

965

How to create backup table in db2?

1089

Explain package in db2 and its advantages?

1207

What is copy pending and check pending in db2?

996

What is dbrm in db2 database?

1108

Why select is not preferred in embedded sql programs?

1298

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2386

Explain the function done by data manager?

1274

What is difference between alias and synonym in db2?

1138

What are the two types of logging in the db2 database? Explain them.

1071

What is db2? Explain.

1039

Why cursor is used in db2?

1036

Why do we need reorg in db2?

984