读代码,读到这么一句sql语句,到pl/sql执行时显示缺失右括号,语句如下:
select*from(selectsum(JE)assumje,month(XSDATE)asxsmonthfromSELLwhereyear(XSDATE)='201...
select * from (select sum(JE) as sumje,month(XSDATE) as xsmonth from SELL where year(XSDATE)='2013' group by month(XSDATE) union select 0,MonthName from GetMonth() where MonthName not in (select month(XSDATE) as xsmonth from SELL where year(XSDATE)='2013' group by month(XSDATE))) temp order by temp.xsmonth
展开
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询