create table taTest(
column1 varchar(50),
column2 varchar(50)
)

select distinct(column1),column2 from taTest;

desired output(for each query result) : column1value(column2value)

select wm_concat(distinct(column1)||'('||column2||')') as result  from taTest;