I have 1000 rows in a db2 table.I want to update first 100
records,How do I do it?
Answer Posted / sireesha
SELECT * FROM TABLE WHERE COUNT(*) = 100;
Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
What is cursor with hold option in db2?
How will you return the number of records in table?
What is database alias db2?
What is db2 command?
How to check sequence on a table in db2?
What are bind parameters in db2?
What is dpf in db2?
what is diffrence b/w file-aid tool and file-aid utility???
How to find the number of rows in db2 tables?
What is difference between rollback and commit?
Give a brief description of db2 isolation levels?
Are view updateable?
When do you specify the isolation level?
Is db2 free?
What is scrollable cursor in db2?