wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes Updating duplicate rows Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Updating duplicate rows" Watch "Updating duplicate rows" New topic
Author

Updating duplicate rows

juniad Ahmed
Greenhorn

Joined: Feb 19, 2011
Posts: 24
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

Joined: Feb 19, 2011
Posts: 24
Its 10 record not 0
 
wood burning stoves
 
subject: Updating duplicate rows
 
Similar Threads
struct in java
Problem with sql query
BufferedReader help
MyPattern.Java - homework help?
Finding Duplicate Records