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


Please Help Members By Posting Answers For Below Questions

What is cursor with hold option in db2?

612


How will you return the number of records in table?

516


What is database alias db2?

605


What is db2 command?

586


How to check sequence on a table in db2?

600






What are bind parameters in db2?

613


What is dpf in db2?

664


what is diffrence b/w file-aid tool and file-aid utility???

4181


How to find the number of rows in db2 tables?

617


What is difference between rollback and commit?

634


Give a brief description of db2 isolation levels?

601


Are view updateable?

627


When do you specify the isolation level?

608


Is db2 free?

684


What is scrollable cursor in db2?

583