title: sql - query instead of group by
body: <p>in my school we learn with oracle sql developer.
  my task is simple.
  I need to count how many identical values in the same column, for example:</p>
  
  <pre><code>  COLA    COLB    COLC    ....
    A       ...     ...     ....
    A       ...     ...     ....
    A       ...     ...     ....
    B       ...     ...     ....
    B       ...     ...     ....
    C       ...     ...     ....
    C       ...     ...     ....
    D       ...     ...     ....
  </code></pre>
  
  <p>so i need the info of: how many A's, how many B's and on.</p>
  
  <p>The important thing is that i can not use group by.
  The only things I can use is:</p>
  
  <p><code>select</code>, <code>from</code>, <code>where</code>, <code>union</code>, <code>intersect</code>,  <code>minus</code>, <code>distinct</code>, <code>count</code>, <code>and</code>, <code>or</code>, <code>as</code>, <code>between</code>.</p>
  
  <p>can not figure that out by now, any help?</p>