title: Show sum of all for every record
body: <p>Say you have table of some items with these two columns: </p>
  
  <ul>
  <li>ItemName</li>
  <li>Price</li>
  </ul>
  
  <p>....where <code>ItemName</code> is unique.</p>
  
  <p>How do you show sum of all prices for every <code>ItemName</code> (I'm using Oracle)? If I just try this:</p>
  
  <pre><code>SELECT ItemName, 
         SUM(Price)
    FROM Items
  </code></pre>
  
  <p>I get this error:</p>
  
  <blockquote>
    <p>ORA-00937: not a single-group group
    function</p>
  </blockquote>
  
  <p>...which goes away only if I use GROUP BY. But then I can SUM only by groups, not all of them.</p>