title: SQL Server 2008 grand total using COMPUTE
body: <p>A simple table query I have shows this:</p>
  
  <pre><code>salesAreaId areaDescription Total
  ----------- --------------- -----------
  N1          North           5
  SE8         Southeast       3
  SW7         Southwest       2
  NE6         Northeast       2
  NW5         Northwest       1
  S3          South           1
  W4          West            1
  E2          East            1
  
  (8 row(s) affected)
  </code></pre>
  
  <p>Here is my code</p>
  
  <pre><code>SELECT st.salesAreaId, areaDescription,  
      COUNT(*) as Total
  FROM store as st, salesArea as sa
  WHERE st.salesAreaId = sa.salesAreaId
  GROUP BY st.salesAreaId, areaDescription
  ORDER BY 3 DESC
  GO
  </code></pre>
  
  <p>My question is how to add a Grand Total row below the total column using COMPUTE, I was taught to use COMPUTE after ORDER BY</p>
  
  <p>I do not want to use ROLLUP, do I need some kind of inside SELECT to use Total separately. 
  Every example I read says to type the column name next to SUM like this
  
  
  <p>Any suggestions?</p>