title: How I remove duplicates from listagg
body: <p>This is my code:</p>
  
  <pre><code>SELECT rule,
         DATASET,
         type,
         LISTAGG(source,';') within GROUP (ORDER BY source) AS source,
         TARGET, 
         LISTAGG(filter,';') within GROUP (ORDER BY filter)  AS filter
  FROM demo_table;
  </code></pre>
  
  <p>My problem is with the two <code>listagg()</code> that I have used. In case of two sources and one filter it is giving duplicate filter and vice versa. What can I add to have only exact number of source and filter?</p>