title: SELECT DISTINCT combination of distinct values, plus non-distinct values?
body: <p>I am having a lot of trouble finding any documentation on executing a simple MySQL query that will return all distinct values from a combination, but also return another column that is not distinct. </p>
  
  <p>In my case <code>report, topic, lat, lng, event</code> must be the distinct combination of values, but I also want to return the <code>docID</code> column. </p>
  
  <p>If I include <code>docID</code> as a distinct value, it returns every document, because each <code>docID</code> is unique.</p>
  
  <p><code>SELECT distinct
   report, topic, lat, lng, event, /*and each of their*/ docID FROM reports</code></p>
  
  <p>I know this question is really simple, but I just can't find any documentation about it.</p>