not set

SELECT BIZ_ID , MIN(DECODE(RN, 1, PROD_MAIN_IMG)) AS IMG1 , MIN(DECODE(RN, 1, PROD_NM)) AS PROD_NM1 , MIN(DECODE(RN, 2, PROD_MAIN_IMG)) AS IMG2 , MIN(DECODE(RN, 2, PROD_NM)) AS PROD_NM2 , MIN(DECODE(RN, 3, PROD_MAIN_IMG)) AS IMG3 , MIN(DECODE(RN, 3, PROD_NM)) AS PROD_NM3 , MIN(DECODE(RN, 4, PROD_MAIN_IMG)) AS IMG4 , MIN(DECODE(RN, 4, PROD_NM)) AS PROD_NM4 , MIN(DECODE(RN, 5, PROD_MAIN_IMG)) AS I..

select 컬럼 , ltrim(sys_connect_by_path(컬럼,','),',') as 컬럼명 from ( select 컬럼 , menurole_id , row_number() over (partition by 그룹컬럼 order by 정렬할컬럼) rn , count (*) over (partition by 그룹컬럼 ) cnt from 테이블명 ) a where level = cnt start with rn = 1 connect by prior 그룹컬럼 = 그룹컬럼 and prior rn = rn-1 ============================================================= CONSRSEQTRADENMRNKCNT 0A건설(50)15 0B건설(15)25 0C건설..