上面的问题因为商品名称无规律一条语句不好实现,这样可不可以: 1、select 班组, 数量=sum(数量) from 代营程控 where 班组 like '%指定营业点%' and 班组 not like '同安%' and 班组 not like '翔安%' and 商品名称 like '%三方通话' group by 班组 order by 班组 2、select 班组, 数量=sum(数量) from 代营程控 where 班组 like '%指定营业点%' and 班组 not like '同安%' and 班组 not like '翔安%' and 商品名称 like '%主叫号码显示' group by 班组 order by 班组 3、select 班组, 数量=sum(数量) from 代营程控 where 班组 like '%指定营业点%' and 班组 not like '同安%' and 班组 not like '翔安%' and 商品名称 like '%呼出限制' group by 班组 order by 班组
1、select 班组,
数量=sum(数量) from 代营程控 where 班组 like '%指定营业点%' and 班组 not like '同安%' and 班组 not like '翔安%'
and 商品名称 like '%三方通话'
group by 班组
order by 班组
2、select 班组,
数量=sum(数量) from 代营程控 where 班组 like '%指定营业点%' and 班组 not like '同安%' and 班组 not like '翔安%'
and 商品名称 like '%主叫号码显示'
group by 班组
order by 班组
3、select 班组,
数量=sum(数量) from 代营程控 where 班组 like '%指定营业点%' and 班组 not like '同安%' and 班组 not like '翔安%'
and 商品名称 like '%呼出限制'
group by 班组
order by 班组