title: SQL Server 2005 - Select top N plus "Other"
body: <p>I have a table for which I want to select top the 5 rows by some column A. I also want to have a 6th row titled 'Other' which sums the values in column A for all but the top 5 rows.</p>
  
  <p>Is there an easy way to do this? I'm starting with:</p>
  
  <pre><code>select top 5 
      columnB, columnA 
  from 
      someTable t
  order by
      columnA desc
  </code></pre>