34,838
社区成员




select
Period,
[Year],
'' as AccountGroup,
Project,
'' as NaturalCode,
ACCNT_NAME,
'' as CostCenter,
sum(Amount) as Amount
from
vw_Journal_Inquiry
WHERE
(PERIOD BETWEEN '201303' AND '201306')
And (Costcenter IN ('0205','020501','020502'))
group by
[Year],
Period,
Project,
ACCNT_NAME
ORDER BY
[Year],
Period,
Project,
ACCNT_NAME
select
Period,
[Year],
'' as AccountGroup,
Project,
'' as NaturalCode,
ACCNT_NAME, --这里是问题
'' as CostCenter,
sum(Amount)over(partition by Project) as Amount
from
vw_Journal_Inquiry
WHERE
(PERIOD BETWEEN '201303' AND '201306')
And (Costcenter IN ('0205','020501','020502'))
ORDER BY
[Year],
Period,
Project,
ACCNT_NAME
你每个ACCNT_NAME都不一样 你那样group by 肯定不行的