Çë½ÌÒ»¸öSQLÓï¾ä

񡜧
aimmonth mark1 summark1
  1      50    60
  2      50    60

±íÖоßÌåÓжàÉÙÌõ¼Ç¼δ֪£¬¾ßÌåÊǼ¸Ô·ÝҲδ֪¡£

Ï£ÍûµÃµ½µÄ½á¹û
aimmonth mark1 summark1
  1      50    60
  2      50    60
  3      0    0
  4      0    0
      ¡£¡£¡£¡£¡£
  12      0    0

---

SQL code:
---²âÊÔÊý¾Ý---
if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([aimmonth] int,[mark1] int,[summark1] int)
insert [tb]
select 1,50,60 union all
select 2,50,60

---²éѯ---
select a.aimmonth,sum(isnull(mark1,0)) as mark1,sum(isnull(summark1,0)) as summark1
from
(select 1 as aimmonth
union all select 2
union all select 3
union all select 4
union all select 5
union all select 6
union all select 7
union all select 8
union all select 9
union all select 10
union all select 11
union all select 12
) a
left join tb b on a.aimmonth=b.aimmonth
group by a.aimmonth


---½á¹û---
aimmonth mark1 summark1
----------- ----------- -----------
1 50 60
2 50 60
3