摘要： 1.一道SQL语句面试题，关于group by表内容：info 表date result2005-05-09 win2005-05-09 lose2005-05-09 lose2005-05-09 lose2005-05-10 win2005-05-10 lose2005-05-10 lose如果要生成下列结果, 该如何写sql语句? win lose2005-05-09 2 22005-05-10 1 2答案：(1) select date, sum(case when result = "win" then 1 else 0 end) as "win" 阅读全文