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.