问题描述:就是想把值为0的字段显示为否,值为1的显示为是
SELECT
case ptc.CLASS_TYPE when '0' THEN '否' when'1' then '是' end as aa
FROM pe_training_class ptc
问题描述:就是想把值为0的字段显示为否,值为1的显示为是
SELECT
case ptc.CLASS_TYPE when '0' THEN '否' when'1' then '是' end as aa
FROM pe_training_class ptc