22,210
社区成员
发帖
与我相关
我的任务
分享
select case when substring(客户编码,2,1) between '0' and '9' then '国内' else '国外' end , sum(销售额) 销售额
from 原表
group by case when substring(客户编码,2,1) between '0' and '9' then '国内' else '国外' end
select 客户=(case when substring(客户编码,2,1)>'9' then '国外' else '国内' end),
sum(销售额)
from tb group by (case when substring(客户编码,2,1)>'9' then '国外' else '国内' end)
select
(case when substring(客户编码,2,1)>'9' then '国外' else '国内' end) as 客户,
sum(销售额)
from
tb
group by
(case when substring(客户编码,2,1)>'9' then '国外' else '国内' end)
select (case when substring(客户编码,2,1)>'9' then '国外' else '国内' end) as 客户,sum(销售额)
from tb group by (case when substring(客户编码,2,1)>'9' then '国外' else '国内' end)
select (case when patindex(sbustring(客户编码,2,1),'1234567890')>0 then '国内' else '国外' end) as OO,
sum(销售额) as XX
from tb
group by (case when patindex(sbustring(客户编码,2,1),'1234567890')>0 then '国内' else '国外' end)