SELECT
COUNT(ID) AS TOTALCOUNT,
SUM(case when PR_TYPE='3' THEN 1 ELSE 0 END) AS WEBCOUNT,
SUM(case when PR_TYPE<>'3' THEN 1 ELSE 0 END) AS OTHERCOUNT
FROM KEWISE.ORD_HEADERS
这句话在ORACLE里直接执行可以运行,在第三方工具中也可以执行,但是放到了Reporting service中,就出现ORA-00907:缺少右括号的问题,网上也查不到,郁闷,谁能帮我?
COUNT(ID) AS TOTALCOUNT,
SUM(case when PR_TYPE='3' THEN 1 ELSE 0 END) AS WEBCOUNT,
SUM(case when PR_TYPE<>'3' THEN 1 ELSE 0 END) AS OTHERCOUNT
FROM KEWISE.ORD_HEADERS
这句话在ORACLE里直接执行可以运行,在第三方工具中也可以执行,但是放到了Reporting service中,就出现ORA-00907:缺少右括号的问题,网上也查不到,郁闷,谁能帮我?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货