标签云

微信群

扫码加入我们

WeChat QR Code

How do I change this SELECT statement to create an adj_b2 column that depends on the same condition as adj_a2 and an adj_b3 that depends on a different condition? SELECT CASEWHEN c.1 > 5THEN COALESCE(a.2,0)*2 ELSE COALESCE(a.2,0)END as adj_a2, a.*, b.*, c.*