try:
select a.ND,to_char(a.WGRQ,'mm') as YF ,sum(a.ZPC) ,
count(select count(SXX) from AJWC22 g
where to_char(WGRQ,'mm')>= to_char(a.WGRQ,'mm') group by ND,GQ)
as XSS
from AJWC21 a
group by to_char(a.WGRQ,'mm') ,a.ND
select a.ND,to_char(a.WGRQ,'mm') as YF ,sum(a.ZPC) ,
count(select count(SXX) from AJWC22 g
where to_char(WGRQ,'mm')>= to_char(a.WGRQ,'mm') group by ND,GQ)
as XSS
from AJWC21 a
group by to_char(a.WGRQ,'mm') ,a.ND
这两个问题难为了我一下午,终于都叫你给解决了,
实在感谢
我现在是要把SQlServer中的程序改到Oracle中,很多语句都不能运行了