果然厉害:谢谢!!!我还有两个同样的问题:
SUM(CASE WHEN (CODE >= '0800' AND CODE <= '0895') THEN 1 ELSE 0 END)
SUM(CASE WHEN (CODE IN ('81','84','91','A1','A2','A3','AA')) THEN 1 ELSE 0 END)
怎么实现了???
SUM(CASE WHEN (CODE >= '0800' AND CODE <= '0895') THEN 1 ELSE 0 END)
SUM(CASE WHEN (CODE IN ('81','84','91','A1','A2','A3','AA')) THEN 1 ELSE 0 END)
怎么实现了???
想不出什么好的方法,这样可以实现的
SUM(decode(CODE,'81',1,'84',1,'91',1,'A1',1,'A2',1,'A3',1,'AA',1,0))
bzszp(www.bzszp.533.net) ( )
zlqs(啊啊啊) ( )
qiansl(小龙) ( )
谢谢!!!!