from t_score a GROUP BY a.`name`;
【sql】之case when then else end
标签：.com style blog span logs com from else when
【sql】之case when then else end
a.`name`,
sum((CASE kemu WHEN ‘语文‘ THEN score ELSE 0 END)) ‘语文‘,
sum((CASE kemu WHEN ‘数学‘ THEN score ELSE 0 END)) ‘数学‘,
sum((CASE kemu WHEN ‘英语‘ THEN score ELSE 0 END))‘英语‘
from t_score a GROUP BY a.`name`;
from t_score a GROUP BY a.`name`;