数据表。列转行：利用max(case when then)。max---聚合函数 取最大值。(case course when &#39；语文&#39；then score else 0 end) ---判断。as 语文---别名作为列名。SELECT `name`.MAX( CASEWHEN course=&#39；语文&#39；THEN score END ) AS 语文.MAX( CASEWHEN course=&#39；数学&#39；THEN score END ) AS 数学，MAX( CASEWHEN course=&#39；英语&#39；THEN score END ) AS 英语FROM studentGROUP BY `name`；。