ÇòÒ»¾äsql - .NET¼¼Êõ / ASP.NET

table A

id income
1 120
2 211
3 116
........


table sum

id total
1 120 --1
2 331 --1+2
3 447 --1+2+3
........


ÈçºÎ°´Ìì»ã×ÜÒÔÀ´µÄÊÕÈ룬sqlÔõôд

---

select sum(Income) from Table
where Date between StartDate and EndDate

§Ö÷±íÊö²»Çå³þ°¡¡£¡£¡£¡£¡£¡£ÉÏÃæµÄ¾ÍÊÇsumÁË£¬×Ô¼º¸ãÇå³þÁ˺ܺÃдµÄ£¬ÎÞ·ÇÊÇgroup byºÍinner joinÖ®ÀàµÄ¡£¡£¡£

---

1 120 
2 331 
3 447 

Õâ¸öÊǸù¾Ýtable A Êä³öµÄsum±í

---

ÒýÓÃ

SQL code
DECLARE @t TABLE (id int,income int)
INSERT INTO @t
SELECT 1 ,120
UNION ALL SELECT 2, 211
UNION ALL SELECT 3 ,116


SELECT b.id,
(SELECT SUM(a.income) from @t a WHERE a.id<=b.id¡­¡­

ÓαêÒ²¿ÉÒÔ£¬²»¹ýÂ¥Éϵĸü¼ò½àµã¡£

---

ÒýÓÃ

SQL code
DECLARE @t TABLE (id int,income int)
INSERT INTO @t
SELECT 1 ,120
UNION ALL SELECT 2, 211
UNION ALL SELECT 3 ,116


SELECT b.id,
(SELECT SUM(a.income) from @t a WHERE a.id<=b.id¡­¡­

ѧϰ¡­¡­

---

¹þ¹þ£¬Ã÷°×ÁË

¶ÔÁË£¬ÄÇselect * from aÈçºÎ¸³¸ø@tÄØŶ£¡

---

Çë½ÌLZ
¿É²»¿ÉÒÔ¸øÎÒÉÔ΢½²Ò»ÏÂ
¡°SELECT b.id, 
  (SELECT SUM(a.income) from @t a