title: Selecting the maximum count from a GROUP BY operation
body: <p>Forgive my SQL knowledge, but I have a <code>Person</code> table with following data - </p>
  
  <pre><code>Id          Name
  ----        ------
  1           a
  2           b
  3           b
  4           c
  </code></pre>
  
  <p>and I want the following result - </p>
  
  <pre><code>Name      Total
  ------    ------
  b         2
  </code></pre>
  
  <p>If I use the <code>GROUP BY</code> query - </p>
  
  <pre><code>SELECT Name, Total=COUNT(*) FROM Person GROUP BY Name  
  </code></pre>
  
  <p>It gives me -  </p>
  
  <pre><code>Name   Total
  ------ ------
  a      1
  b      2
  c      1
  </code></pre>
  
  <p>But I want only the one with maximum count. How do I get that?</p>