案例一
查询每一时间段胜的总数,负的总数
select
a_time,
COUNT(CASE WHEN sf = '胜' then sf END) '胜',
COUNT(CASE WHEN sf = '负' then sf END) '负'
from A
GROUP BY a_time
查询结果
案例二
查询输出1,2,3,4月份的数据
select
b_year,
sum(case when b_month = '1' then amount end) 'm1',
sum(case when b_month = '2' then amount end) 'm2',
sum(case when b_month = '3' then amount end) 'm3',
sum(case