日期:2014-05-17 浏览次数:20988 次
select sum(a.putinmoney),b.PROJECTID from YO_PROJECT_DOMESTIC_PER a, YO_PROJECT_DOMESTIC_SIGNED b where a.projectid(+) = b.projectid group by b.PROJECTID;
------解决方案--------------------
select --a.putinmoney,
a.PUTINFIXEDASSETS,
a.OUTINVESTMENTPUTINMONEY,
to_char(a.PERFORMANCEDATE, 'yyyy-mm-dd') PERFORMANCEDATE,
b.SIGNEDCLASSID,
b.FILLGROUPID,
to_char(b.FILLDATE, 'yyyy-mm-dd') FILLDATE,
b.PROJECTNAME,
b.CONTRACTAMOUNT,
b.PROJECTID,
sum(a.putinmoney) over (partition by b.PROJECTID order by b.PROJECTID),
(select c.name from UUPMS_ENUMS c where c.ENUM_ID = b.SIGNEDCLASSID) SIGNEDCLASSIDNAME,
(select c.name from UUPMS_ENUMS c where c.ORG = b.FILLGROUPID) FILLGROUPIDname
from YO_PROJECT_DOMESTIC_PER a, YO_PROJECT_DOMESTIC_SIGNED b
where a.projectid(+) = b.projectid;
------解决方案--------------------
SELECT SUM(A.PUTINMONEY), B.PROJECTID FROM YO_PROJECT_DOMESTIC_PER A, YO_PROJECT_DOMESTIC_SIGNED B WHERE A.PROJECTID(+) = B.PROJECTID GROUP BY B.PROJECTID