title: Remove almost duplicate records from table
body: <p>Starting from this query</p>
  
  <pre><code>SELECT DISTINCT Name,Manufacturer,Model,RevisionID FROM dbo.COMPUTER_TABLE ORDER BY Name,RevisionID
  </code></pre>
  
  <p>I get to the following table:</p>
  
  <pre><code>(Name,Manufacturer,Model,RevisionID)
  
  UST8923 | Microsoft | Surface 2 | 1
  UST8923 | Microsoft | Surface 2 | 2
  UST8923 | Microsoft | Surface 3 | 3
  UST8923 | Microsoft | Surface 3 | 4
  CAD4258 | Lenovo | Thinkpad P1 | 1
  CAD4258 | Lenovo | Thinkpad P1 | 2
  CAD4258 | Dell | Latitude 5480 | 3
  </code></pre>
  
  <p>I need to get only the records with the highest RevisionID and discard the rest.
  So, I need to get this result:</p>
  
  <pre><code>UST8923 | Microsoft | Surface 3 | 4
  CAD4258 | Dell | Latitude 5480 | 3
  </code></pre>
  
  <p>Any ideas?</p>