查询数据库中本月的日期,1到31日,有时数据库中没有日期也按1到31来显还将
SELECT DISTINCT
CONVERT(varchar(100), shou_dtime, 23) AS a1, SUM(CAST(shou_xj AS decimal)) AS a, SUM(CAST(shou_sm AS decimal)) AS b, SUM(CAST(shou_wx AS decimal)) AS c,
SUM(CAST(shou_zfb AS decimal)) AS d, SUM(CAST(shou_sk AS decimal)) AS e, SUM(CAST(shou_fq AS decimal)) AS f, SUM(CAST(shou_tk AS decimal)) AS g,
SUM(CAST(shou_hkxj AS decimal)) AS h, SUM(CAST(shou_hksm AS decimal)) AS i, SUM(CAST(shou_hkwx AS decimal)) AS j, SUM(CAST(shou_hkzfb AS decimal)) AS k,
SUM(CAST(shou_hksk AS decimal)) AS l
FROM tb_make_shoufei
WHERE (YEAR(shou_dtime) = '2019') AND (MONTH(shou_dtime) = '05')
GROUP BY shou_dtime
HAVING (SUM(CAST(shou_xj AS decimal) + CAST(shou_sm AS decimal) + CAST(shou_wx AS decimal) + CAST(shou_zfb AS decimal) + CAST(shou_sk AS decimal)
+ CAST(shou_fq AS decimal) + CAST(shou_tk AS decimal) + CAST(shou_hkxj AS decimal) + CAST(shou_hksm AS decimal) + CAST(shou_hkwx AS decimal)
+ CAST(shou_hkzfb AS decimal) + CAST(shou_hksk AS decimal) + CAST(shou_hkfq AS decimal)) > 0)
ORDER BY a1
现在能查询出来,可是日期会因为后面的金额分组一天成多行,日期只要一行,金