mysql-订单状态统计

zhu.lin

已于 2023-07-18 15:52:27 修改

阅读量246

点赞数

文章标签： mysql 数据库

于 2023-06-29 16:28:10 首次发布

zhulin

本文链接：https://blog.csdn.net/weixin_47164700/article/details/131459115

版权

统计订单各个状态的数量

 select count(1)                                                         totalcount,
  sum(case when u.order_state = 0 then 1 else 0 end)                     zerocount,
  sum(case when u.order_state = 1 then 1 else 0 end)                     onecount,
  sum(case when u.order_state = 2 and u.pay_state = 1 then 1 else 0 end) twocount,
  sum(case when u.order_state = 3 then 1 else 0 end)                     threecount,
  sum(case when u.order_state = 4 then 1 else 0 end)                     threecount,
  sum(case when u.order_state = 9 then 1 else 0 end)                     threecount
        from tb_order_info u