求解答，一道sql的问题
题目大概就是图片上的内容，请大佬们指点一下
2018-02-25 11:22 末流双非 Java
关注
全部评论
今晚不吃菜
深圳大学 安卓
SELECT
A AS '日期',
SUM(CASE WHEN B='胜' THEN 1 ELSE 0 END) AS `胜`,
SUM(CASE WHEN B='负' THEN 1 ELSE 0 END) AS `负`
FROM `table` GROUP BY A;
或 SELECT
A AS '日期',
SUM(IF(B='胜', 1, 0) AS `胜`,
SUM(IF(B='负', 1, 0) AS `负`
FROM `table` GROUP BY A;
康师傅瓶装饮用水
University of Bristol 测试工程师
拆成两个表，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;
全能
美团_rd
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;
Isen 楼主
楼主 末流双非 Java
想了很久，也试着写了几条但是结果都不对
相关推荐
网易游戏公司福利 533人发布 点赞 评论 收藏
分享
点赞 评论 收藏
分享