title: List names alphabetically with count in desc order
body: <p>I need a solution with a mysql query, it's basically depends on the two order by fields, here is the scenario,</p>
  
  <p>I have a table, say <code>abc</code> with the fields like,</p>
  
  <pre><code>auto_id  name  count_values
  
  1        html      10  
  2        css       29  
  3        js        65  
  4        jquery     3  
  5        html5      9  
  6        asp       58  
  7        php       34  
  8        xcode      6  
  ....  
  </code></pre>
  
  <p>so on (more than 100 records)  </p>
  
  <p>So I need the result, which basically list all the name with count_values, based on the<br>
  <code>name &gt; alphabetically</code> + <code>count_values &gt; maximum</code>  </p>
  
  <p>I have tried with  </p>
  
  <pre><code>Select 
    distinct name,
    count_values 
  from 
    abc 
  where 
    count_values &gt; 0 
  group by 
    name 
  order by 
    name asc, count_values desc 
  limit 0, 10;
  </code></pre>
  
  <p>But the result is showing the names in alphabetical order where as I have some big count on xcode data row which is not in the list.  </p>