Concatenate the results

Database

Concatenate the results

Hello All,

I have my results from a query as

Col 1

STD

FMLA

I would like to concatenate STD and FMLA to obtain as

Col 1

STD/FMLA

Any help is appreciated

Thanks,

Reddy

1 REPLY
Junior Supporter

Re: Concatenate the results

sel temp.value2,row_number() over (order by temp.value2) as rownum1

from (

sel a.Acct_Nbr || '/'  ||  b.Acct_Nbr as value1 from  tduser.checking_tran1 a cross join tduser.checking_tran1 b 

where a.Acct_Nbr<>b.Acct_Nbr

) temp(value2)

qualify rownum1 =1

create table checking_tran1  with data 'abc', and 'def' and test.

o/p - abc/def