sql:case when
select distinct Date,
sum(case Result when '胜' then 1 else 0 end) as '胜',
sum(case Result when '负' then 1 else 0 end) as '负'
from test
group by date
(case FieldName when 'FieldValue' then 1 else 0 en...
原创
2019-08-13 00:02:35 ·
256 阅读 ·
0 评论