select name, count(order_id) ,
count(if(status =1,order_id,null)) as '租赁中',
count(if(status =2,order_id,null)) as '已完成',
count(if(status =4,order_id,null)) as '取消'
from t_order group by name ;
mysql 分组条件统计查询
最新推荐文章于 2024-05-16 14:56:10 发布