title: mysql sort before group by
body: <p>I think this is the <a href="https://stackoverflow.com/questions/5140785/mysql-order-before-group-by/5140943#5140943">best solution</a>.  However, this query is not solve my issue - I have like this table:</p>
  
  <pre><code>+--+-------+-----+
  |id|user_id|score|
  +--+-------+-----+
  |1 |1      |5    |
  +--+-------+-----+
  |2 |1      |16   |
  +--+-------+-----+
  |3 |1      |15   |
  +--+-------+-----+
  </code></pre>
  
  <p>Query:</p>
  
  <pre><code>  SELECT *
      FROM (`_scorboard`)
  GROUP BY `user_id`
    HAVING `score` = MAX(score)
  ORDER BY `score` desc 
  
  result 0 rows
  </code></pre>
  
  <p>Why is it returns 0 records ?</p>