case....when ...多重判断

 

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,

posted on 2019-03-12 20:32  辉仔一刀  阅读(1821)  评论(0编辑  收藏  举报