title: Update two different rows in a single row
body: <p>Here My table looks like in MS-SQL</p>
  
  <pre><code>ID   Name   Mark1    Mark2    Grade
  1    ABC    50       75       A+
  2    XYZ    0        15       A+
  3    XYZ    20       0        B+
  </code></pre>
  
  <p>I need the result should be like:-</p>
  
  <pre><code>ID   Name   Mark1    Mark2
  1    ABC    50       75
  2    XYZ    20       15
  </code></pre>
  
  <p>If ID, Name are matches i need to display the Mark1 &amp; Mark2 value
  in a single row but there grade is different like the same i have to update
  multiple rows please help on this.</p>
  
  <p>Note:- Grade is not required in the final result set and 3rd row is not required once values get updated we need to remove the 3rd row.</p>
  
  <p>Here I have added:- </p>
  
  <p>Input:-  </p>
  
  <pre><code>ID   Name   Mark1    Mark2    Grade
  
  1    ABC    50       75       A+
  
  2    XYZ    0        15       A+
  
  3    XYZ    20       0        B+
  
  4         ZZZ         30                0                   B+
  
  4         ZZZ          40                0                   B+
  
  4         ZZZ         50                0                   B+  
  </code></pre>
  
  <p>Output:- </p>
  
  <pre><code>ID   Name   Mark1    Mark2    Grade
  
  1    ABC    50       75       A+
  
  2    XYZ    20       15       A+
  
  4    ZZZ       30                0                   B+
  
  4    ZZZ         40                0                   B+
  
  4    ZZZ         50                0                   B+
  </code></pre>