sid name age
3 suresh 24 2 surya 25 4 arya 26 1 kamal 23 1 karun 36 1 varun 36 1 anil 60 5 arun 50 5 ganga 60 5 gouna 30
From the above table we can identify that 4 rows with sid 1 and 3 rows with sid 5. Like this table may contains multiple records with same sid. Here my requirement is "I have to update those records which contains same sid basing on one condition. The condition is if more than 2 rows contains same sid then only i have to update those records. For example in the above table 4 rows are there with sid 1. I have to update these 4 rows like this
first row(having sid 1) with 'lilitha' as a value for name column second row(having sid 1) with 80 as a value for age column third row (having sid 1) with 'suri' as a value for name column fourth row (having sid 1) with 40 as a value for age column"
like this i have to update the records with sid 5 also. please help me in resolving this problem.