title: Get Highest value from items with same IDs
body: <p>I have a table like this:</p>
  
  <pre><code>ID      Severity    WorkItemSK
  23636   3-Minor     695119
  23636   3-Minor     697309
  23647   2-Major     695081
  23647   2-Major     694967
  </code></pre>
  
  <p>In here I have several WorkItems that share the same ID. How can I get unique IDs that have the highest WorkItem?</p>
  
  <p>So it would like this:</p>
  
  <pre><code>ID      Severity    WorkItemSK
  23636   3-Minor     697309
  23647   2-Major     695081
  </code></pre>
  
  <p>Help the noob :) Mind giving a clue what SQL commands (again I am a noob) should I use? Or an example of a query?</p>
  
  <p>Thank you in advance!</p>