title: Oracle SQL return count(*) column along side of regular column?
body: <p>In Oracle SQL, how do I return count(*) column along side of a regular column?</p>
  
  <h1>What works:</h1>
  
  <pre><code>select count(*) from TABLE where username = 'USERNAME';
  </code></pre>
  
  <h1>What I'd like to work:</h1>
  
  <pre><code>select username,count(*) from TABLE where username = 'USERNAME';
  </code></pre>
  
  <p>So I want the username along side of the count, to expand this into another query that lists numerous usernames and the count of their records.</p>
  
  <h1>Error:</h1>
  
  <pre><code>ORA-00937: not a single-group group function
  00937. 00000 -  "not a single-group group function"
  *Cause:    
  *Action:
  Error at Line: 7 Column: 7
  </code></pre>
  
  <h1>Question:</h1>
  
  <p>So, how do I do it?</p>