title: Cross update taking values from another column based on duplicates found in SQL
body: <p>I have a table_A containing duplicate records in column ID,but has distinct E_ID for each duplicate ID.I have retrieved records using below mention query.</p>
  
  <pre><code>select ID,E_ID,Comments
  from table_A
  where ID in (SELECT ID
                  FROM table_A t where ID !=' '
                  GROUP BY ID 
                  HAVING COUNT(distinct E_ID) &gt; 1
                 )
  group by ID,E_ID,Comments order by ID
  </code></pre>
  
  <p>This query will give me output like this</p>
  
  <pre><code> ID |  E_ID   | Comments
  11101   | 55237 | Null
  11101   | 15243 | Null
  11103   | 55249 | Null
  11103   | 15286 | Null
  11107   | 55255 | Null
  11107   | 15290 | Null
  </code></pre>
  
  <p>Now i want to UPDATE Comments column which will give me output like below shown table.
  Note:please look into comments sentences carefully,you see E_ID differences</p>
  
  <pre><code>ID  |  E_ID         | Comments
  11101   |  55237    | Duplicate of E_ID 15243
  11101   |  15243    | Duplicate of E_ID 55237
  11103   |  55249    | Duplicate of E_ID 15286
  11103   |  15286    | Duplicate of E_ID 55249
  11107   |  55255    | Duplicate of E_ID 15290
  11107   |  15290    | Duplicate of E_ID 55255
  </code></pre>
  
  <p>You could see that E_IDs are cross update in Comments column for each duplicate ID.
  I need a update Query to achieve this,Please help.
  I really don't know how to tile this.</p>