title: listagg function without group by
body: <p>I have alot of columns in <code>select</code> statement, many of which are derived calculations. </p>
  
  <p>I am trying to group multiple rows into one using <code>listagg()</code> in <code>select</code> statement, but without having to <code>group by</code> rest of columns in <code>select</code> statement. Along the lines of <code>listagg() within group() over (partition by id)</code>.</p>
  
  <p>Right now I have something along the lines of:</p>
  
  <pre><code>select id, listagg(distinct annual_bill_rate, ', ') within group (order by bill_rate) as annual_bill_rate, email, state
  from table
  group by 1,3,4
  </code></pre>
  
  <p>It doesnt seem to be possible to avoid this group by based on documentation, but are there alternatives? I have 30+ columns, I can't group by all of them. Thank you!</p>
  
  <p>Sample data:</p>
  
  <pre><code>id   bill_rate   email        state 
  1    0.0035      a@gmail.com  NJ
  1    0.0045      a@gmail.com  NJ
  1    0.0055      a@gmail.com  NJ
  2    0.0065      b@gmail.com  NY
  2    0.0075      b@gmail.com  NY
  3    0.0085      c@gmail.com  PA
  </code></pre>
  
  <p>Desired result- WITHOUT GROUP BY:</p>
  
  <pre><code>id   bill_rate                email        state 
  1    0.0035, 0.0045, 0.0055   a@gmail.com  NJ
  2    0.0065, 0.0075           b@gmail.com  NY
  3    0.0085                   c@gmail.com  PA
  </code></pre>