表格如下图所示:
需统计每个日期下win的次数与lose的次数
SELECT date,SUM(CASE type WHEN "win" THEN 1 ELSE 0 END) win,
SUM(CASE type WHEN "lose" THEN 1 ELSE 0 END) lose FROM
test2 GROUP BY date;
查询结果如下图所示:
表格如下图所示:
需统计每个日期下win的次数与lose的次数
SELECT date,SUM(CASE type WHEN "win" THEN 1 ELSE 0 END) win,
SUM(CASE type WHEN "lose" THEN 1 ELSE 0 END) lose FROM
test2 GROUP BY date;
查询结果如下图所示: