|
with table1 as
(select '1010' Code, '001' brcd, 100000 금액 from dual union all
select '1010' Code, '002' brcd, 100000 금액 from dual union all
select '1010' Code, '003' brcd, 100000 금액 from dual union all
select '1020' Code, '001' brcd, 100000 금액 from dual union all
select '1020' Code, '002' brcd, 100000 금액 from dual union all
select '1020' Code, '003' brcd, 100000 금액 from dual union all
select '1030' Code, '001' brcd, 100000 금액 from dual union all
select '1030' Code, '002' brcd, 100000 금액 from dual union all
select '1030' Code, '003' brcd, 100000 금액 from dual
)
select * from table1
위와 같은테이블이 있습니다... 오라클 버전은 8.1.5 입니다.
이것을 조회하면 아래처럼 나타납니다
1010 001 100000
1010 002 100000
1010 003 100000
1020 001 100000
1020 002 100000
1020 003 100000
1030 001 100000
1030 002 100000
1030 003 100000
저는 이것을 아래처럼 조회 하고 싶습니다..
1010 001 100000
002 100000
003 100000
1020 001 100000
002 100000
003 100000
1030 001 100000
002 100000
003 100000
오라클버전이 8.1.5 라는것..종일 이렇게 저렇게 머리굴려도 떠오르지 않는군요...
|
