存储过程中的 条件筛选 选择内容映射

存储过程中的 选择 结果映射

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