title: MySQL: Exclude duplicate data
body: <p>In one of my columns, there's are duplicates and I want to grab the first occurrence only. How can I do that? In the example, I want to grab all the rows that are unique in col C. So I only want <code>hello ladies</code>, <code>hello team</code>, <code>hello cats</code>, and <code>hello sexy</code></p>
  
  <pre><code>Example Table
  ---------------
  
  column A | col B | col C 
  --------------------------
  hello    | ladies| 1
  hello    | guys  | 1
  hello    | team  | 2
  hello    | dogs  | 2
  hello    | cats  | 3
  hello    | cats  | 3
  hello    | sexy  | 4
  </code></pre>