需求描述：在sql server 中創(chuàng)建一張表。create table test( dqtime datetime, dmoney money)插入數(shù)據(jù)：insert into test values('2017/10/1',1000)insert into test values('2017/9/1',2000)本人寫的sql查詢語句select month(dqtime) ,sum(dmoney) from test group by month(dqtime)得到結(jié)果：9      200010     10000期望查詢的結(jié)果:1     02     0....9     200010   100011   012   0要求：就是每次查詢?nèi)绻掌诹兄袩o該月的數(shù)據(jù)。則以0顯示