안녕하세요
조회쿼리 짜는데 잘 않되서 고수님들께 질문좀 부탁드리려구요
IP장부를 한눈에 볼수 있도록 만들고 있습니다.
원본
B_CLASS | D_CLASS | CONTENTS |
4 | 1 | A1 |
2 | A2 | |
3 | A3 | |
4 | A4 | |
5 | A5 | |
6 | A6 | |
5 | 1 | B1 |
2 | B2 | |
3 | B3 | |
4 | B4 | |
5 | B5 | |
6 | B6 | |
6 | 1 | C1 |
2 | C2 | |
3 | C3 | |
4 | C4 | |
5 | C5 | |
6 | C6 |
출력하고 싶은 화면
CLASS | 4 | 5 | 6 |
1 | A1 | B1 | C1 |
2 | A2 | B2 | C2 |
3 | A3 | B3 | C3 |
4 | A4 | B4 | C4 |
5 | A5 | B5 | C5 |
6 | A6 | B6 | C6 |
오늘까지 만들어야 하는데 도와주세요 ㅠㅠ..
WITH t AS ( SELECT 4 b_class, 1 d_class, 'A1' contents FROM dual UNION ALL SELECT 4, 2, 'A2' FROM dual UNION ALL SELECT 4, 3, 'A3' FROM dual UNION ALL SELECT 4, 4, 'A4' FROM dual UNION ALL SELECT 4, 5, 'A5' FROM dual UNION ALL SELECT 4, 6, 'A6' FROM dual UNION ALL SELECT 5, 1, 'B1' FROM dual UNION ALL SELECT 5, 2, 'B2' FROM dual UNION ALL SELECT 5, 3, 'B3' FROM dual UNION ALL SELECT 5, 4, 'B4' FROM dual UNION ALL SELECT 5, 5, 'B5' FROM dual UNION ALL SELECT 5, 6, 'B6' FROM dual UNION ALL SELECT 6, 1, 'C1' FROM dual UNION ALL SELECT 6, 2, 'C2' FROM dual UNION ALL SELECT 6, 3, 'C3' FROM dual UNION ALL SELECT 6, 4, 'C4' FROM dual UNION ALL SELECT 6, 5, 'C5' FROM dual UNION ALL SELECT 6, 6, 'C6' FROM dual ) SELECT * FROM t PIVOT (MIN(contents) FOR b_class IN (4, 5, 6)) ORDER BY d_class ;