title: TSQL adding "Other" to a GROUP by Percentage Query
body: <p>How would I construct a query that would classify anything under a certain percentage as Other?</p>
  
  <p>For example with:</p>
  
  <pre><code>Select Country, (COUNT(Country)*100 / (Select COUNT(*) From Logs)) as Perc
  FROM Logs
  Group by Country
  HAVING (COUNT(Country)*100 / (Select COUNT(*) From Logs)) &gt; 5
  ORDER BY Perc DESC
  </code></pre>
  
  <p>How would I add a row "Other" that would the sum of everything less than 6 percent?</p>