SQL 按日期和金额排列

查询数据库中本月的日期，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

图片说明

现在能查询出来，可是日期会因为后面的金额分组一天成多行，日期只要一行，金

https://zhidao.baidu.com/question/1431583216768236099.html

不知道你这个问题是否已经解决, 如果还没有解决的话:

建议你看下这篇博客👉 ：sql报错--日期格式图片在转换整个输入字符串之前结束

如果你已经解决了该问题, 非常希望你能够分享一下解决方案, 写成博客, 将相关链接放在评论区, 以帮助更多的人 ^-^