title: Multiply 2 columns in sql and to sum all the results using SQL
body: <p>I write a query to multiply to colums now i would like to sum up the result that i am getting can any one give me an idea</p>
  
  <p>this is what i wrote</p>
  
  <p><code>select Rate,Qty,(Rate*Qty) as result 
   from tblName</code></p>
  
  <p>I will get result say for example <code>40 90</code> now i would like to sum these results</p>