HBUP001N |
A |
AUADL |
HBUP001N |
C |
AUADL |
HBUP001N |
L |
AUADL |
HBUP001N |
A |
AUFRE |
HBUP001N |
C |
AUFRE |
HBUP001N |
L |
AUFRE |
HBUP001N |
A |
AUMEL |
HBUP001N |
C |
AUMEL |
HBUP001N |
L |
AUMEL |
HBUP001N |
C |
MYPKG |
HBUP001N |
L |
MYPKG |
HBUP001N |
A |
SGSIN |
HBUP001N |
C |
SGSIN |
HBUP001N |
L |
SGSIN |
HBUP001S |
A |
AUADL |
HBUP001S |
C |
AUADL |
HBUP001S |
L |
AUADL |
HBUP001S |
C |
AUFRE |
HBUP001S |
L |
AUFRE |
HBUP001S |
A |
AUMEL |
HBUP001S |
C |
AUMEL |
HBUP001S |
L |
AUMEL |
HBUP001S |
L |
MYPEN |
HBUP001S |
C |
MYPKG |
HBUP001S |
L |
MYPKG |
HBUP001S |
C |
SGSIN |
HBUP001S |
L |
SGSIN |
위에는 테이블(TEST_TABLE) 예제입니다.
COL2 의 우선순위는 A>C>L순입니다.
결과는
HBUP001N |
A |
AUADL |
HBUP001N |
A |
AUFRE |
HBUP001N |
A |
AUMEL |
HBUP001N |
C |
MYPKG |
HBUP001N |
A |
SGSIN |
HBUP001S |
A |
AUADL |
HBUP001S |
C |
AUFRE |
HBUP001S |
A |
AUMEL |
HBUP001S |
L |
MYPEN |
HBUP001S |
C |
MYPKG |
HBUP001S |
C |
SGSIN |
이렇게 나와야 합니다.
이게 SQL로 가능한지요?
|