mysql 查询每个店铺的总金额和各个状态的总金额

摘要： 查询每个店铺的总金额和各个状态的总金额 SELECT shop_id,sum(amount),sum(if( status = 0,amount,0)) as sum1,sum(if( status = 1,amount,0)) as sum2,sum(if( status = 2,amount,0 阅读全文
posted @ 2025-10-15 18:36 少杨 阅读(5) 评论(0) 推荐(0)