데이터베이스 질문과 답변
안녕하세요
세로 데이터를 가로로 표현 하는 SQL 만드는 방법 때문에 글 작성 합니다 ㅠㅠ
이런 경우는 당최 모르겠습니다... 부탁드립니다..
[데이터]
SELECT 'A' AS CODE, 'APPLE' AS NAME, 1 AS SEQ FROM DUAL UNION ALL
SELECT 'B' AS CODE, 'ORANGE' AS NAME, 2 AS SEQ FROM DUAL UNION ALL
SELECT 'C' AS CODE, 'BANANA' AS NAME, 3 AS SEQ FROM DUAL
[결과 값]
| 1 | 2 | 3 |
| A | B | C |
| APPLE | ORANGE | BANANA |
by 마농
[2022.08.03 15:38:46]
WITH t AS ( SELECT 'A' code, 'APPLE' name, 1 seq FROM dual UNION ALL SELECT 'B', 'ORANGE', 2 FROM dual UNION ALL SELECT 'C', 'BANANA', 3 FROM dual ) SELECT * FROM t UNPIVOT (v FOR gb IN (code, name)) PIVOT (MIN(v) FOR seq IN (1, 2, 3)) ;
by 재래개
[2022.08.03 16:29:17]
감사합니다!!!!!!!!!!
) 버튼을 클릭하여 작성 하시면 됩니다.