这是一道面试题,加油哦
select a.rq, a.s as 胜, b.f as 负 from (select rq, count(st) as s from test where st = '胜' group by rq) a,
(select rq, count(st) as f from test where st = '负' group by rq) b where a.rq = b.rq
结果:
这是一道面试题,加油哦
select a.rq, a.s as 胜, b.f as 负 from (select rq, count(st) as s from test where st = '胜' group by rq) a,
(select rq, count(st) as f from test where st = '负' group by rq) b where a.rq = b.rq
结果: