Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Updating duplicate rows

 
juniad Ahmed
Greenhorn
Posts: 24
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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



 
juniad Ahmed
Greenhorn
Posts: 24
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Its 10 record not 0
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic