title: Retrieving Top 10 rows and sum all others in row 11
body: <p>I have the following query that retrieve the number of users per country;</p>
  
  <pre><code>SELECT C.CountryID AS CountryID, 
         C.CountryName AS Country, 
         Count(FirstName) AS Origin
  FROM Users AS U
  INNER JOIN Country AS C ON C.CountryID = U.CountryOfOrgin
  GROUP BY CASE C.CountryName, 
                C.CountryID
  </code></pre>
  
  <p>What I need is a way to get the top 10 and then sum all other users in a single row. I know how to get the top 10 but I`m stuck on getting the remaining in a single row. Is there a simple way to do it?</p>
  
  <p>For example if the above query returns 17 records the top ten are displayed and a sum of the users from the 7 remaining country should appear on row 11. On that row 11 the countryid would be 0 and countryname <code>Others</code></p>
  
  <p>Thanks for your help!</p>