with tb as(select 'ID' as ids,'CODE' AS co,'' m1 from dual Union all select 'ID' as ids ,'' as co ,'NAME' m1 from dual) select ids , wm_concat(co) co, wm_concat(m1) m1 from tb group by ids
SELECT MAX(ids) as ids,max(co) as co,max(m1) as m1 FROM ( select 'ID' as ids,'CODE' AS co,'' m1 from dual Union all SELECT 'ID' AS ids ,'' AS co ,'NAME' m1 FROM dual );
With tb_data As (Select 'ID' As ids, 'CODE' As co, '' m1 From dual Union All Select 'ID' As ids, '' As co, 'NAME' m1 From dual) Select ids, Max(co) co, Max(m1) m1 From tb_data Group By ids;
tb as(select 'ID' as ids,'CODE' AS co,'' m1 from dual
Union all
select 'ID' as ids ,'' as co ,'NAME' m1 from dual)
select ids ,
wm_concat(co) co,
wm_concat(m1) m1
from tb
group by ids
(
select 'ID' as ids,'CODE' AS co,'' m1 from dual
Union all
SELECT 'ID' AS ids ,'' AS co ,'NAME' m1 FROM dual
);
(Select 'ID' As ids, 'CODE' As co, '' m1
From dual
Union All
Select 'ID' As ids, '' As co, 'NAME' m1 From dual)
Select ids, Max(co) co, Max(m1) m1 From tb_data Group By ids;