Re: [SQL ] COUNT出來值依序加總
※ 引述《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
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 111.252.123.172
討論串 (同標題文章)