title: How to sum count value in SQL Server?
body: <p>How to sum count value in SQL Server ?</p>
  
  <p>I have table 1. I want to sum count value.</p>
  
  <p>How to do that ?</p>
  
  <pre><code>SELECT Top 10 count(d.name) as countname,d.name as name ,sum(count(d.name)) as sumcount
  FROM table 1 as d 
  group by d.name order by count(d.name) desc
  </code></pre>
  
  <p>I want to display <code>countname</code>, <code>name</code>, <code>sumcount</code>. How to do that ?</p>