title: SELECT DISTINCT on one column
body: <p>Using SQL Server, I have...</p>
  
  <pre><code>ID  SKU     PRODUCT
  =======================
  1   FOO-23  Orange
  2   BAR-23  Orange
  3   FOO-24  Apple
  4   FOO-25  Orange
  </code></pre>
  
  <p>I want </p>
  
  <pre><code>1   FOO-23  Orange
  3   FOO-24  Apple
  </code></pre>
  
  <p>This query isn't getting me there. How can I SELECT DISTINCT on just one column?</p>
  
  <pre><code>SELECT 
  [ID],[SKU],[PRODUCT]
  FROM [TestData] 
  WHERE ([PRODUCT] = 
  (SELECT DISTINCT [PRODUCT] FROM [TestData] WHERE ([SKU] LIKE 'FOO-%')) 
  ORDER BY [ID]
  </code></pre>