posted 12 years ago
Hi Guys i am facing a problem updating all but one duplicate rows. If i have 0 duplicate record in my table i should update 9 records and leave the other record as it is. For example
if i have the following records
Id Fname Lname
1 abc xyz
2 abc xyz
3 abc xyz
4 abc xyz
5 abc xyz
6 abc xyz
7 abc xyz
8 abc xyz
9 abc xyz
10 abc xyz
after i run the query the result should be some thing like this
Id Fname Lname
1 abc xyz
2 abc xyz_1
3 abc xyz_2
4 abc xyz_3
5 abc xyz_4
6 abc xyz_5
7 abc xyz_6
8 abc xyz_7
9 abc xyz_8
10 abc xyz_9