title: SQL Sum Multiple rows into one
body: <p>I need some help with the SUM feature.  I am trying to SUM the bill amounts for the same account into one grand total, but the results I am getting show my SUM column just multiples my first column by 3.</p>
  
  <p>Here is what I want as results for my mock data:</p>
  
  <pre><code>AccountNumber    Bill      BillDate   
  1                100.00    1/1/2013     
  1                150.00    2/1/2013   
  1                200.00    3/1/2013 
  2                75.00     1/1/2013  
  2                100.00    2/1/2013   
  </code></pre>
  
  <p>Query:</p>
  
  <pre><code>SELECT AccountNumber, Bill, BillDate, SUM(Bill)
  FROM Table1
  GROUP BY AccountNumber, Bill, BillDate
  
  
  AccountNumber    Bill      BillDate    SUM(Bill)
  1                100.00    1/1/2013    450.00    
  1                150.00    2/1/2013    450.00
  1                200.00    3/1/2013    450.00
  2                75.00     1/1/2013    175.00
  2                100.00    2/1/2013    175.00
  </code></pre>
  
  <p>OR</p>
  
  <pre><code>AccountNumber    Bill      SUM(Bill)
  1                100.00    450.00    
  2                75.00     175.00
  </code></pre>
  
  <p>I would prefer to have both results if possible.</p>
  
  <p>Here is what I am getting:</p>
  
  <p>My SUM column is just multiplying by three, it's not actually summing the data based on account Number. </p>
  
  <pre><code>AccountNumber    Bill      BillDate    SUM(Bill)
  1                100.00    1/1/2013    300.00    
  1                150.00    2/1/2013    450.00
  1                200.00    3/1/2013    600.00
  2                75.00     1/1/2013    225.00
  2                100.00    2/1/2013    300.00
  </code></pre>