title: SQL Server - SUM(Column) * QtyColumn
body: <p>Is it possible to get the total without returning it in multiple rows (Group BY)?</p>
  
  <p>Example:</p>
  
  <p>Data: </p>
  
  <pre><code>ID    Amount   Quantity
  1     50       1 
  2     50       2
  </code></pre>
  
  
  
  <pre><code>select sum(Amount) * Quantity, SUM(Quantity) as totalQuantity 
    from tbl
  </code></pre>
  
  <p>I want the results to be in 1 row:    </p>
  
  <pre><code>total       totalQuantity 
  150         3
  </code></pre>