title: How to get unique values from specific column in SQL Server?
body: <p>I have a table</p>
  
  <pre><code>tblFruit_ID tblFruit_FruitType tblFruit_FruitName
  --------------------------------------------------
  1            Citrus              Orange
  2            Citrus              Lime
  3            Citrus              Lemon
  4            Seed                Cherry
  5            Seed                Banana 
  </code></pre>
  
  <p>I can't set <code>distinct for tblFruit_FruitType</code> column only, and if I use <code>group by</code> (I want only count function), then also I am getting an error.</p>
  
  <p>My expected output:</p>
  
  <pre><code>tblFruit_ID   tblFruit_FruitType   tblFruit_FruitName
  ------------------------------------------------------
     1            citrus                   orange
     4            seed                     cherry
  </code></pre>