CD1 |
CD2 |
|
CD2 |
A |
B |
|
A |
|
C -> |
|
B |
|
A |
|
C |
F |
D |
|
D |
|
E |
|
E |
|
|
|
F |
SELECT 'A' CD1 , 'B' CD2 FROM DUAL UNION ALL
SELECT '' , 'C' CD2 FROM DUAL UNION ALL
SELECT '' , 'A' CD2 FROM DUAL UNION ALL
SELECT 'F' , 'D' CD2 FROM DUAL UNION ALL
SELECT '' , 'E' CD2 FROM DUAL
위의 데이타를 아래처럼 나오게 하고 싶어요.
QUERY 부탁합니다.
SELECT 'A' CD2 FROM DUAL UNION ALL
SELECT 'B' CD2 FROM DUAL UNION ALL
SELECT 'C' CD2 FROM DUAL UNION ALL
SELECT 'D' CD2 FROM DUAL UNION ALL
SELECT 'E' CD2 FROM DUAL UNION ALL
SELECT 'F' CD2 FROM DUAL |