方式1 select name, sum(case when subject=‘语文’ then score else 0 end) as chinese, sum(case when subject=‘数学’ then score else 0 end) as math from test group by name 方式二示例 multiIf、if写法