title: MySQL counting the returned count of a result set
body: <p>My current query looks like this:</p>
  
  <pre><code>SELECT DISTINCT (member), count( UID ) AS numUID
  FROM memberdata
  GROUP BY Member
  ORDER BY count( UID ) DESC
  </code></pre>
  
  <p>What I get back, looks a lot like this:</p>
  
  <pre><code>A name 1    175
  A name 2    38
  A name 3    37
  A name 4    36
  A name 5    36
  </code></pre>
  
  <p>What I want to do now is get the count of numUID, in the above example I may get a result like:</p>
  
  <pre><code>**numUID**   **COUNT**
     175           1
     38            1
     37            1
     36            2
  </code></pre>
  
  <p>I've searched far and wide, but I can't seem to get the information I need to put this query together properly. Any help would be appreciated.</p>
  
  <p>Thanks,</p>