sql是求每月一项字段的累加,按照日期与月份分组的,请指点,谢谢
这是在另一个数据库运行的,语法没有错误,但在sql server 2008R2 就报错了,请指点
sql server 2005引入Row_number()
over(PARTITION BY..ORDER BY.. ) 不能用Sum
用sum要Group By
我只修正over(PARTITION BY..ORDER BY.. )
不清楚你要查什么,所以没有修正其它语法错误,比如没有Group by
select * from (
select t.jh, mth, sum (ryou_ sum) as ryou_suml,Row_number() over (PARTITION BY jh ORDER BY mth ) num from
(select jh, month (rq) mth, sum (ryou) ryou_ sum from CSJING_ SCSJB
where rq >='2022-01-01' and rq<='2022-12-31' group by month(rq),jh) t) tt
pivot
(max (ryou_ sum1 )
for mth in ([1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12])) as x