实现方案: COALESCE嵌套NULLIF
sql
SELECT company, COALESCE(NULLIF(turnover, 0), revenue) AS revenue FROM company_profile;
SELECT company, COALESCE(NULLIF(turnover, 0), revenue) AS revenue FROM company_profile;
postgresql - Coalesce for zero instead of null - Stack Overflow