title: Concatenate the LISTAGG output with other columns
body: <p>I need to concatenate the outputs in same query. Is it possible to do this?</p>
  
  <p>Example query:</p>
  
  <p><code>Concat(c.manames,a.transaction_amt_us) as concat
  listagg(i.settlement_type,',')within group (order by i.settlement_type) as settlement_type,</code></p>
  
  <p>I want to concatenate both outputs i.e concat and settlement_type and get in one column.</p>
  
  <p>something like:
  <code>Concat(concat,settlement_type)</code></p>
  
  <p>Help me resolve this.</p>