title: Teradata/SQL sum together columns
body: <p>I have a query that returns two amounts.  I would like to sum them together, while leaving one as it is returned by the query.</p>
  
  <p>For example:</p>
  
  <pre><code>DESC | sum(AMOUNT)
  A | -61149025.940000
  B | -9696.910000
  </code></pre>
  
  <p>B needs to be the sum of B and A and replace the current value.  A stays as is on the result of the query.</p>
  
  <p>My SQL is similar to this:</p>
  
  <pre><code>Select SQ.DESC, SUM(SQ.AMOUNT)
  FROM (subquery) SQ
  GROUP by SQ.DESC
  </code></pre>
  
  <p>My return results would be</p>
  
  <pre><code>DESC | sum(AMOUNT)
  A | -61149025.940000
  B | -61158722.850000
  </code></pre>
  
  <p>I have not been able to logically make sense of this</p>