select d.keep_id,
d.keep_subsidy,
CASE WHEN d.keep_subsidy=0 THEN ‘0‘
ELSE d.keep_subsidy_number
END
AS keep_subsidy_number,
d.keep_general
from sys_capital_account_insured d
原文：https://www.cnblogs.com/Cuimc/p/11850127.html