title: Using Distinct(col) in a SELECT with more than one column selected
body: <p>my goal is to return a distinct list of 'mFrom' and only pull the latest 'date' from 'messages' table..</p>
  
  <pre><code>Table: messages
  id     mFrom     mTo   date
  --     -----     ---   ----
  int    int       int   datetime
  </code></pre>
  
  <p>I am trying to use this query:</p>
  
  <pre><code>SELECT DISTINCT(mFrom), date FROM messages WHERE mTo = '116'
  </code></pre>
  
  <p>But am receiving these results:</p>
  
  <pre><code>mFrom   date
  9     | 2016-11-17 00:30:03
  11    | 2016-11-17 12:35:08
  11    | 2016-11-17 12:35:35
  </code></pre>
  
  <p>and I would like to see these results instead..</p>
  
  <pre><code>mFrom  date
  9     | 2016-11-17 00:30:03
  11    | 2016-11-17 12:35:35
  </code></pre>
  
  <p>Any help is appreciated.  Saw similar answers using GROUP BY and an inner SELECT but having trouble coming up with a comparable query for my specific fields.. </p>