title: How to Find ALL Most Common Values in SQL?
body: <p>How would I go about showing <strong>ALL</strong> most common values in SQL?</p>
  
  <p>So I have the query to show the most common value here bellow.</p>
  
  <pre><code>SELECT name, COUNT(*) AS popularity
  FROM cattwo 
  GROUP BY name 
  ORDER BY popularity DESC 
  LIMIT 1;
  
      +----------+------------+
      | name     | popularity |
      +----------+------------+
      | cat22610 |          7 |
      +----------+------------+
  </code></pre>
  
  <p>However, when I display the top 10 most common value the result is ... </p>
  
  <pre><code>SELECT name, COUNT(*) AS popularity 
  FROM cattwo 
  GROUP BY name 
  ORDER BY popularity DESC 
  LIMIT 10;
  
      +----------+------------+
      | name     | popularity |
      +----------+------------+
      | cat22610 |          7 |
      | cat68704 |          7 |
      | cat14153 |          7 |
      | cat52476 |          7 |
      | cat4556  |          7 |
      | cat64173 |          7 |
      | cat5586  |          7 |
      | cat89302 |          6 |
      | cat97131 |          6 |
      | cat42010 |          6 |
      +----------+------------+
  </code></pre>
  
  <p>The goal is to display all cats with the highest popularity. Something like this. </p>
  
  <pre><code>+----------+------------+
  | name     | popularity |
  +----------+------------+
  | cat22610 |          7 |
  | cat68704 |          7 |
  | cat14153 |          7 |
  | cat52476 |          7 |
  | cat4556  |          7 |
  | cat64173 |          7 |
  | cat5586  |          7 |
  +----------+------------+
  </code></pre>
  
  <p>Help would be great. Thanks in advance. </p>