请教关于行转列问题
[解决办法]
SELECT Name , ClassName , Grade,
[优]=MAX(CASE WHEN [level]='优' THEN paperCount ELSE 0 END ),
[良]=MAX(CASE WHEN [level]='良' THEN paperCount ELSE 0 END ),
[中]=MAX(CASE WHEN [level]='中' THEN paperCount ELSE 0 END ),
[差]=MAX(CASE WHEN [level]='差' THEN paperCount ELSE 0 END )
FROM TB
GROUP BY Name , ClassName , Grade
