oracle的case when两个字段的用法

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