I have 1000 rows in a db2 table.I want to update first 100
records,How do I do it?
Answer Posted / rama krishna.
UPDATE DB2 SET COL=VAR/EXPR WHERE ROWNUM<=1OO;
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What is precompiler in db2?
What is db2 bind?
How to take backup of table in db2?
What is clone table?
What does db2 mean?
What is performance tuning db2?
How do I optimize a query in db2?
How to find schema of a table in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is the difference between nvl and coalesce?
List out the data types available.
How do we specify index to include or not during bind process.
What is a cursor in programming?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?