CASE...WHEN 进行多重判断
CASE WHEN A IS NOT NULL
THEN B
WHEN C IS NULL
THEN
CASE WHEN D IS NOT NULL
THEN E
ELSE 0
END
END contract_amount_total,
CASE...WHEN 进行多重判断
CASE WHEN A IS NOT NULL
THEN B
WHEN C IS NULL
THEN
CASE WHEN D IS NOT NULL
THEN E
ELSE 0
END
END contract_amount_total,
转载于:https://www.cnblogs.com/studynode/p/10519467.html