title: Oracle - Using a Case Statement with Count
body: <p>I have the below piece of query and it runs but not producting what I want.</p>
  
  <p>Query:</p>
  
  <pre><code>select id
  ,CASE WHEN COUNT(id ) &gt; 1  THEN 'X'
   ELSE  ' ' END AS Dual
  from x
  group by id
  </code></pre>
  
  <p>Results:</p>
  
  <pre><code>ID    Dual
  1      
  1
  </code></pre>
  
  <p>I would like to see: </p>
  
  <pre><code>ID       Dual
  1         x
  1         x
  </code></pre>