※ 引述《allllllll1 (1l1l1l1l)》之銘言：
: SELECT
: YEAR A
: MONTH A
: COUNT B
: FROM X
: GROUP BY YEAR A , MONTH A
: ORDER BY YEAR A , MONTH A
: 會出現
: A A B
: 請問有辦法把B欄位依序加總嗎
: SUM(COUNT)會出錯
self join，利用 on 條件找出前列的資料，例如:
create table CumulativeLab
(
id int,
numData int,
primary key (id)
)
go
insert into CumulativeLab values (1, 100)
insert into CumulativeLab values (2, 220)
insert into CumulativeLab values (3, 303)
insert into CumulativeLab values (4, 440)
insert into CumulativeLab values (5, 555)
go
select a.id, a.numData, sum(b.numData) as CumulativeNum
from CumulativeLab a inner join CumulativeLab b on a.id >= b.id
group by a.id, a.numData
order by a.id
go