title: Select first 10 distinct rows in mysql
body: <p>Is there any way in MySQL to get the first 10 distinct rows of a table. </p>
  
  <p>i.e. Something like...</p>
  
  <pre><code>SELECT TOP 10 distinct * 
  FROM people 
  WHERE names='SMITH'
  ORDER BY names asc
  </code></pre>
  
  <p>However this method doesn't actually work, because it gives the error: "Syntax Error. Missing operator in query expression distinct *"</p>