title: Update one row only out of two identical rows in sybase
body: <p>I have three rows in the database out of those two are identical. Out of those two same rows I have to make changes in one using the sybase.Ex.</p>
  
  <pre><code>Row1: ABC 456 ancient block
  Row2: ABC 456 ancient block
  Row3: DEF 678 class   block
  </code></pre>
  
  <p>I have to make changes in one of the first two block by changing ABC to XYZ.If there are only two identical blocks then I am doing the below method.</p>
  
  <pre><code>begin transaction AA
  set rowcount 1
  update table 
  set col1 = XYZ
  where col1 = ABC
  commit transaction AA
  set rowcount 0
  </code></pre>
  
  <p>It is easy if there are two identical rows but if two identical and one different then sybase picks the unique row and updates it. Can someone tell how to solve this three rows problem ?
  I am using aseisql for the Sybase.</p>