title: How to find out sum in a group by function monthwise?
body: <p>In the table <code>TRANSACTIONTABLE</code> are three columns: <code>VendorID, TransacDate, Amount</code>. The output I require is the data which will contain the sum(Amount) group by vendor but should be month-wise. The output should be somewhat like this: The columns will be..</p>
  
  <pre><code> VendorID, JAN'14, FEB'14, Mar'14 and so on....
  </code></pre>
  
  <p>I have tried the following: <code>SELECT VENDORID, SUM(AMOUNT) from TRANSACTIONTABLE where TRANSACDATE BETWEEN '2014-01-01' and '2014-01-31'</code>.... Then again for feb, mar and so on. Then I copied the result on to an excel doing a vlookup each time. This is taking time.</p>
  
  <p>Each month column will contain the sum of amount for that particular vendor for that particular month. Any help on this is appreciated.</p>