title: How to Sum multiple lines in sql
body: <p>I have multiple lines of data all sharing the same Company id.</p>
  
  <p>Is there a way to 'sum' all the amounts to give me one line of data per company id using SQL Server Management Studio 2005?</p>
  
  <p>For example I currently have the below data......</p>
  
  <pre><code>Company_Name   Company_ID   Amount
  Company 6         10024   120
  Company 6         10024   569
  Company 6         10024    53
  Company 6         10024   100
  Company 6         10024   564
  Company 7         10638  9500
  Company 7         10638   105
  Company 7         10638   624
  </code></pre>
  
  <p>What i would like to try and get is.......</p>
  
  <pre><code>Company_ Name   Company_ID     Amount 
  Company 6        10024         1406
  Company 7        10638        10229
  </code></pre>
  
  <p>Is there a way of doing this?</p>
  
  <p>Any advice pointing me the right way would be great.</p>
  
  <p>Thanks,</p>