select t.temp ,count(t.win),count(t.falses) from ( select temp, (case result when '胜' then result end) win, (case result when '负' then result end) falses from test_demo ) t group by t.temp
转载于:https://www.cnblogs.com/BKYMei99099/p/3578562.html
select t.temp ,count(t.win),count(t.falses) from ( select temp, (case result when '胜' then result end) win, (case result when '负' then result end) falses from test_demo ) t group by t.temp
转载于:https://www.cnblogs.com/BKYMei99099/p/3578562.html