title: Two levels of grouping on one set of data. Is it possible
body: <p>I'm running a query that breaks up percentages by country.. something like this:</p>
  
  <pre><code> select country_of_risk_name, (sum(isnull(fund_weight,0)*100)) as 'FUND WEIGHT' from       OFI_Country_Details
  WHERE FIXED_COMP_FUND_CODE = 'X'
  GROUP BY country_of_risk_name
  </code></pre>
  
  <p>This returns me the right output. This can range anywhere from 1 Country to 100 countries. How can I write my logic that it shows me the top 5 highest percentages and then groups all those outside the top 5 into an 'Other' category? Example output:</p>
  
  <ol>
  <li>USA - 50%</li>
  <li>Canada - 10%</li>
  <li>France - 4%</li>
  <li>Spain - 2%</li>
  <li>Italy - 1.7%</li>
  <li>Other - 25%</li>
  </ol>