数据统计sql语句

最新推荐文章于 2024-03-09 09:46:12 发布

bokeofzhangxingbing

最新推荐文章于 2024-03-09 09:46:12 发布

阅读量410

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/bokeofzhangxingbing/article/details/52995378

版权

数据库专栏收录该内容

2 篇文章 0 订阅

订阅专栏

        SELECT
                  (SELECT COUNT(1) FROM order_info WHERE pay_status=1 AND shipping_status=0 AND retailers_id=#{retailersId}) AS orderWaitCount ,
                 (SELECT IFNULL(SUM(order_price),0) from order_info where (order_create_time BETWEEN '${begTime}' AND '${endTime}' ) AND pay_status=1 AND retailers_id=#{retailersId} ) AS money,
       (SELECT COUNT(1) FROM customer where (regist_time BETWEEN '${begTime}' AND '${endTime}' ) AND retailers_id=#{retailersId}) AS userNewCount,
          (SELECT COUNT(1) FROM testing_info where testing_status=0 AND (bind_time BETWEEN '${begTime}' AND '${endTime}' ) AND retailers_id=#{retailersId}) boxBindCount,
                (SELECT COUNT(1) FROM testing_info where testing_status=1 AND (modify_on BETWEEN '${begTime}' AND '${endTime}' ) AND retailers_id=#{retailersId}) boxAcceptCount,
                (SELECT COUNT(1) FROM testing_info where testing_status=4 AND (modify_on BETWEEN '${begTime}' AND '${endTime}' ) AND retailers_id=#{retailersId}) boxTestCount,
               (SELECT COUNT(1) FROM testing_info where testing_status=5 AND (modify_on BETWEEN '${begTime}' AND '${endTime}' ) AND retailers_id=#{retailersId}) boxEndCount