unpivot
-
[MSSQL] 컬럼을 로우로 변경하여 출력WEB/MSSQL 2020. 12. 9. 09:35
[MSSQL] 컬럼(COLUMN)을 로우(ROW)로 변경하여 출력 WITH TEMP_TABLE AS ( SELECT '1반' AS '반정보', '일월' AS '이름', 90 AS '국어', 90 AS '영어', 80 AS '수학' UNION ALL SELECT '2반' AS '반정보', '이월' AS '이름', 70 AS '국어', 80 AS '영어', 60 AS '수학' UNION ALL SELECT '3반' AS '반정보', '삼월' AS '이름', 50 AS '국어', 70 AS '영어', 40 AS '수학' ) SELECT * FROM TEMP_TABLE WITH TEMP_TABLE AS ( SELECT '1반' AS '반정보', '일월' AS '이름', 90 AS '국어', 90 AS '영어',..