title: SQL - Displaying entries that are the max of a count?
body: <pre><code>CREATE TABLE doctor( patient CHAR(13), docname CHAR(30) );
  </code></pre>
  
  <p>Say I had a table like this, then how would I display the names of the doctors that have the most patients? Like if the most was three and two doctors had three patients then I would display both of their names.</p>
  
  <p>This would get the max patients:</p>
  
  <pre><code>SELECT MAX(count) 
  FROM (SELECT COUNT(docname) FROM doctor GROUP BY docname) a;
  </code></pre>
  
  <p>This is all the doctors and how many patients they have:</p>
  
  <pre><code>SELECT docname, COUNT(docname) FROM doctor GROUP BY name;
  </code></pre>
  
  <p>Now I can't figure out how to combine them to list only the names of doctors who have the max patients.</p>
  
  <p>Thanks.</p>