mysql 쿼리입니다 . select ROWNUM, MAX(case when TBL.CHLDRN_ROLE = 'ROOT' then TBL.PARNTS_ROLE else null end) AS A1, MAX(case when TBL.CHLDRN_ROLE = 'ROLE_ADMIN' then TBL.PARNTS_ROLE else null end) as A2, MAX(case when TBL.CHLDRN_ROLE = 'ROLE_USER_MEMBER' then TBL.PARNTS_ROLE else null end) as A3 from ( select row_number() over(order by CHLDRN_ROLE) as ROWNUM,CHLDRN_ROLE,PARNTS_ROLE from LETTNROLES_HIERARCHY ) as TBL group by ROWNUM
이렇게 쿼리를 짰는데
이걸 null 을 없애고 .
ROLE_ADMIN ROLE_USER_MEMBER ROLE_ANONYMOUS 한줄로 나타낼 방법이없을까요 ..