统计胜负
1.表数据
初始化表sql
CREATE TABLE tmp(rq VARCHAR(10),shengfu NCHAR(1))
INSERT INTO tmp VALUES('2005-05-09','胜');
INSERT INTO tmp VALUES('2005-05-09','胜');
INSERT INTO tmp VALUES('2005-05-09','负');
INSERT INTO tmp VALUES('2005-05-09','负');
INSERT INTO tmp VALUES('2005-05-10','胜');
INSERT INTO tmp VALUES('2005-05-10','负');
INSERT INTO tmp VALUES('2005-05-10','负');
查询结果：
sql
SELECT rq,SUM(shengfu='胜') '胜',SUM(shengfu='负') '负' FROM tmp GROUP BY rq;
SELECT rq,SUM(CASE WHEN shengfu='胜' THEN 1 ELSE 0 END),SUM(CASE WHEN shengfu='负' THEN 1 ELSE 0 END) FROM tmp GROUP BY rq