存储过程中的 选择 结果映射
SELECT
(case when MainType ='SBDJ' then '123' when MainType ='SBGL' then '设备管理' end) as 'name',
MainType,
SubTypeName
FROM tb_SYS_DD as f WHERE Remark='yes' AND MainType<>'KHXX'
GROUP BY SubTypeName,MainType,SubType
标签:存储,映射,SubTypeName,when,MainType,筛选 From: https://www.cnblogs.com/aashui/p/16915695.html