title: Display top three values and the sum of all other values
body: <p>After I <code>ORDER BY cnt DESC</code> my results are</p>
  
  <pre><code>fld1  cnt
   A     9
   E     8
   D     6
   C     2
   B     2
   F     1
  </code></pre>
  
  <p>I need to have top 3 displayed and the rest to be summed as 'other', like this:</p>
  
  <pre><code>fld1  cnt
  A      9
  E      8
  D      6
  other  5
  </code></pre>
  
  <p>EDITED:</p>
  
  <p>Thank you all for your input. Maybe it will help if you see the actual statement:</p>
  
  <pre><code>SELECT 
      CAST(u.FA AS VARCHAR(300)) AS FA,
      COUNT(*) AS Total,
      COUNT(CASE WHEN r.RT IN (1,11,12,17) THEN r.RT END) AS Jr,
      COUNT(CASE WHEN r.RT IN (3,4,13) THEN r.RT END) AS Bk,
      COUNT(CASE WHEN r.RT NOT IN (1,11,12,17,3,4,13) THEN r.RT END ) AS Other
  FROM R r
      INNER JOIN DB..RTL rt
      ON r.RT = rt.RTID
      INNER JOIN U u
      ON r.UID = u.UID
  WHERE rt.LC = 'en' 
  GROUP BY CAST(u.FA AS VARCHAR(300))--FA is ntext
  ORDER BY Total DESC
  </code></pre>
  
  <p>The produced result has 19 records. I need to show the top 5 and sum up the rest as "Other FA". I don't want to do a select from a select from a select with this kind of statement. I am more looking for some SQL function. Maybe ROW_NUMBER is good idea, but I don't know how exactly to apply it in this case.</p>