拆成两个表,t1记录胜的场数,t2记录负的场数 select t1.date, t1.win, t2.lose from (select A as 'date', count(B) as 'win' from T where B='win' group by A) as t1, (select A as 'date', count(B) as 'lose' from T where B='lose' group by A) as t2 where t1.date=t2.date;
点赞 3

相关推荐

迷茫的大四🐶:那你问他上班之后老实了没
点赞 评论 收藏
分享
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务