case when 销售组 like 'SGA%' THEN CASE WHEN 销售组='SGA-BMS' THEN 'SGA-BMS' 

                                       WHEN 销售组='SGA-W&NP' THEN 'SGA-W&NP'

   ELSE 'SGA-Phone'

   END

WHEN 销售组 like 'SGB%' THEN 'SGB'

WHEN 销售组 like 'SGC%' OR 销售组 like 'BUD%' OR 销售组 like 'BUE%' OR 销售组 like 'SGD%'  THEN 'SGC'

WHEN 销售组 like '汽车%' THEN '汽车'

WHEN 销售组 like '半导体%' THEN '半导体'

WHEN 销售组 like '乔峰%' THEN '乔峰'

else '其他'

end as ttype

group by 后面为

case when 销售组 like 'SGA%' THEN CASE WHEN 销售组='SGA-BMS' THEN 'SGA-BMS' 

                                       WHEN 销售组='SGA-W&NP' THEN 'SGA-W&NP'

   ELSE 'SGA-Phone'

   END

WHEN 销售组 like 'SGB%' THEN 'SGB'

WHEN 销售组 like 'SGC%' OR 销售组 like 'BUD%' OR 销售组 like 'BUE%' OR 销售组 like 'SGD%'  THEN 'SGC'

WHEN 销售组 like '汽车%' THEN '汽车'

WHEN 销售组 like '半导体%' THEN '半导体'

WHEN 销售组 like '乔峰%' THEN '乔峰'

else '其他'

end

要多套一个子查询就行了。你先把case when 全判断出来。然后子查询再group by

select * from (你原来的查询语句，，case when的判断那一些)  t group by 销售组

SELECT (CASE WHEN 销售组 LIKE 'SGA-BMS%' OR 销售组 LIKE 'SGA-W&NP%' THEN 销售组 

WHEN 销售组 LIKE 'SGA%' THEN 'SGA-Phone'

WHEN 销售组 LIKE 'SGB%' THEN 'SGB'

WHEN 销售组 LIKE 'SGC%' OR 销售组 LIKE 'BUE%' OR 销售组 LIKE 'SGD%'THEN 'SGC'

WHEN 销售组 LIKE '汽车%' THEN '汽车'

WHEN 销售组 LIKE '半导体%' THEN '半导体'

WHEN 销售组 LIKE '乔峰%' THEN '乔峰'

ELSE '其他' END

) AS FL FROM ............