본문 바로가기
반응형

with2

WITH 문에서 테이블을 두개 맹글어 보자. 원래 WITH문 이게 메인이 아닌데.. GROUP BY에 대한 고찰이었음.. =ㅅ= 마땅한 제목이 없어서. ㅋㅋㅋㅋㅋ 1. 테스트 테이블 생성 WITH tb1 AS ( select 'A' as k1 , 1 as qty from dual union all select 'B', 2 from dual union all select 'B', 3 from dual union all select 'C', 1 from dual ), tb2 AS ( select 'A' as b1 , '나무' as b2 from dual union all select 'B', '문어바' from dual union all select 'B', '꼬라바' from dual union all select 'C', '거북이' from dua.. 2009. 3. 13.
over(partition by) 를 사용해 보자. 종합 선물 세트다. with, union all, decode, row_number(), over(partition by) 가 나온다. with kk as ( select '강군' as aa,'배고플때' as bb, '바나나' as cc from dual union all select '강군','배고플때','멍멍이' from dual union all select '강군','배부를때','고래' from dual union all select '강군','배부를때','참치' from dual union all select '강군','정신없을때','해삼' from dual union all select '강군','배부를때','바나나' from dual union all select '케이씨','정신없을때','.. 2008. 8. 28.
반응형

티스토리툴바