sql 的分类汇总问题

[elkxie]

数据如下
aa 100
bb 150
cc 120
dd 130
ee.....

要求分类汇总如下
aa 100
bb 150
XX （其余所有的和，即cc+dd+ee+...）

[631799]

select max(字段1) 字段1,sum(字段2) 字段2 from 表 group by case when 字段1='aa' then 1 when 字段1='b' then 2 else 3 end

[elkxie]

受了两位哥哥的启发， 我在帮助里找到了个写法很好懂：
SELECT Category =
CASE type
WHEN 'popular_comp' THEN 'Popular Computing'
WHEN 'mod_cook' THEN 'Modern Cooking'
WHEN 'business' THEN 'Business'
WHEN 'psychology' THEN 'Psychology'
WHEN 'trad_cook' THEN 'Traditional Cooking'
ELSE 'Not yet categorized'
END,
CAST(title AS varchar(25)) AS 'Shortened Title',
price AS Price
FROM titles
非常方便实用。不过还是给两位散分（杭州工人那种写法我还没运行出）

[僵哥]

select field_1,sum(field_2) as field_2 from
(
select (case when field_1='aa' or field_1='bb' then field_1 else 'xx' end) as field_1,field_2 from Table_1
)
virt_table
group by field_1