No, ELSE is a catch-all. In your example, it's not clear why you would want to include a condition in the ELSE clause, since you've already ... ... <看更多>

The SQL CASE StatementThe CASE statement goes through conditions and returns a value when the first condition is met (like an IF-THEN- ELSE ... ... <看更多>

,CASE WHEN i.DocValue ='F2' AND c.CondCode IN ('ZPR0','ZT10','Z305') THEN c.CondVal ELSE 0 END as Value. There are two types of CASE ... ... <看更多>