select EID_TYPE_NAME,
count(case when EID_TYPE_NAME = '中心' then 1 else null end) center_number,
count(case when EID_TYPE_NAME = '整省' then 1 else null end) province_number,
count(case when EID_TYPE_NAME = '客服' then 1 else null end) customer_number,
count(case when EID_TYPE_NAME = '零售' then 1 else null end) retail_number
from DW_LC_EID
where EID_TYPE_NAME in ('中心', '整省', '客服', '零售')
group by EID_TYPE_NAME;
orcale case when
最新推荐文章于 2024-04-18 16:05:18 发布