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
15894 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

How many databases are there?

1112

What is the role of data manager in the db2 database?

1159

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2162

What is plan in cobol db2?

1206

What is null value in db2?

1078

What are the bind parameters ibm db2?

1105

How to rename a table in DB2 ?

1147

What parameters are used to control the free space in DB2?

1096

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

11745

What is table space in db2?

1072

What is multi row fetch in db2?

1104

Explain in detail about buffer manager and its functionalities?

1145

How to access db2 tables in mainframe?

1104

How to create db2 table in mainframe?

1220

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

7207