数据表 id date score name
1 2012-12-1 80 A
2 2012-12-9 50 A
2 2012-12-2 90 B
3 2012-11-4 50 C问下 按月份分组 怎么 写SQL语句 12月份的数据 A 65
B 90
C 0
SQL SERVER 2008sql serversql
1 2012-12-1 80 A
2 2012-12-9 50 A
2 2012-12-2 90 B
3 2012-11-4 50 C问下 按月份分组 怎么 写SQL语句 12月份的数据 A 65
B 90
C 0
SQL SERVER 2008sql serversql
from table
group by convert(varchar(7),date),name
from table a right join
(select distinct name from table) b on a.name=b.name
where convert(varchar(7),date)='2012-12'
group by convert(varchar(7),date),name
select '2012-12' as date,b.name,sum(isnull(score,0))score
from #t a right join
(select distinct name from #t) b on a.name=b.name
and convert(varchar(7),date)='2012-12'
group by convert(varchar(7),date),b.name