SQLÑ­環ÇóºÍ - MS-SQL Server / »ù´¡Àà

請Çó幫æ.
±íÖÐÓÐgltr_eff_dt,¸úgltr_amt 兩個×Ö¶Î,

gltr_eff_dt gltr_amt
2000/01/01 1
2000/01/02 3
2000/01/03 -1
2000/01/04 1
2000/01/05 8
2000/01/06 -5
.
.
.
.
2010/04/30 10

   
ÎÒÏëÑ­環µÃµ½Ï±íÒ»個結¹û,


year(gltr_eff_dt) month(gltr_eff_dt) sum(gltr_amt)
2000 1 100
2000 2 110
.
.
.

2010 4 120


條¼þÊÇ gltr_eff_dt <= Äê.Ô µÄËùÓÐgltr_amtµÄºÍ

謝謝

---

SQL code:
select year(gltr_eff_dt)[year],
month(gltr_eff_dt)[month],
(select sum(gltr_amt)
from tb
where convert(varchar(7),gltr_eff_dt,120)<convert(varchar(7),t.gltr_eff_dt,120))
from tb t

---

SQL code:
select year(gltr_eff_dt)[year],
month(gltr_eff_dt)[month],
(select sum(gltr_amt)
from tb
where convert(varchar(7),gltr_eff_dt,120)<convert(varchar(7),t.gltr_eff_dt,120))
from tb t
group by year(gltr_eff_dt),month(gltr_eff_dt)

---

ÒýÓÃ

SQL code
select year(gltr_ef