题目:
利用sql实现行转列
答案:
SELECT user_id
,SUM( CASE WHEN subject = 'chinese' THEN score ELSE 0 END ) AS chinese
,SUM( CASE WHEN subject = 'math' THEN score ELSE 0 END ) AS math
,SUM( CASE WHEN subject = 'english' THEN score ELSE 0 END ) AS english
FROM chengji
GROUP BY user_id