title: Maximum Count of Distinct Values in SQL
body: <p>please forgive me if this has been answered, but could not find it using the search tool or a basic google query.</p>
  
  <p>I am trying to return a value that indicates the maximum number of rows any distinct value in a column in SQL.</p>
  
  <p>For example, I'd like to use something like</p>
  
  <pre><code>SELECT MAX(COUNT(DISTINCT person_id) AS MAX_NUM_PERS_ROW
  FROM mytable
  </code></pre>
  
  <p>and if the person with most rows in the table had 5 rows, the value returned would be 5...</p>
  
  <p>Any and all help is appreciated!</p>