title: How to get the desired output using sql
body: <p>I have my DB table looks like the following</p>
  
  <pre><code>IDCol    Col1    Col2    Col3
  ID1      1       3       1000
  ID1      6       6       1000
  ID2      3       4       500
  ID2      1       7       500
  </code></pre>
  
  <p>I need the output as the following<br/></p>
  
  <pre><code>IDCol    Col1    Col2    Col3
  ID1      1       6       1000
  ID2      3       7       500
  </code></pre>
  
  <p>Is there a possibility that I could get the above desired output format using SQL?
  I am a newbie to SQL and could some one please help me? Thank you very much!</p>