InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Suppose I Have 1000 Rows In A Db2 Table. I Want To Update First 100 Records, How Do I Do It? |
|
Answer» is there identity column in this table, for EXAMPLE, if there is a column indexnum int(SUPPOSED start from 1), you can use the UPDATE Table Set XXX=XXX where indexnum < 101 is there identity column in this table, for example, if there is a column indexnum int(supposed start from 1), you can use the Update Table Set XXX=XXX where indexnum < 101 |
|