title: Selecting multiple maximum rows
body: <p>Suppose I have a MySQL table named <code>Domain</code>. How can I find the most popular email domain from this table. Directly I want to find all rows with the maximum count.</p>
  
  <pre><code>Domain    
  gmail.com    
  gmail.com    
  gmail.com    
  yahoo.com    
  yahoo.com    
  yahoo.com    
  rediffmail.com    
  rediffmail.com
  mail.com
  </code></pre>
  
  <p>My desired output:</p>
  
  <pre><code>Domain      No_of_users
  gmail.com   3
  yahoo.com   3
  </code></pre>