热门标签
热门文章
当前位置: article > 正文
如何使用SQL中的条件计算每月的总销售额？_sql计算每月的销售总额
作者：小桥流水78 | 2024-08-08 23:04:12
赞
踩
sql计算每月的销售总额
create_time 分组月份的依据
deal_number 按照月份分组的金额
select Month(create_time) as 'Month'
, sum(deal_number) as 'Total Sales'
-- You can even add a count of loans at the same time.
, sum(case when deal_number <= 0 then 1 else 0 end) as 'Total Loans'
from pay_order
group by Month(create_time);
- 1
- 2
- 3
- 4
- 5
- 6
声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小桥流水78/article/detail/950288
推荐阅读
相关标签
