SELECT dotime,(select count(*) FROM `test1` as  a where result='胜' and a.dotime=b.dotime) as 胜, (select count(*) FROM `test1` as c where result='负' and c.dotime=b.dotime) as 负 FROM `test1` as b GROUP BY dotime;
点赞 评论

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务