select
(select count(*) from orderID WHERE createTime > '2019-12-06 00:00:00' and createTime < '2019-12-13 23:59:59' and appraiseTime > '2019-12-06 00:00:00' and appraiseTime < '2019-12-13 23:59:59' and rate = '5') as count_rate5,
(select count(*) from orderID WHERE createTime > '2019-12-06 00:00:00' and createTime < '2019-12-13 23:59:59' and appraiseTime > '2019-12-06 00:00:00' and appraiseTime < '2019-12-13 23:59:59' and rate is not NULL) as count_customer,
(select count(*) from orderID WHERE createTime > '2019-12-06 00:00:00' and createTime < '2019-12-13 23:59:59' and appraiseTime > '2019-12-06 00:00:00' and appraiseTime < '2019-12-13 23:59:59') as count_all
;
多条sql,统一返回数据
最新推荐文章于 2022-11-08 23:49:53 发布