title: Oracle SQL Query for monthwise report
body: <p>Guys i have a table called <strong>A</strong> which has columns as </p>
  
  <pre><code>-----
    A
  -----
  S_DATE
  DUR
  VIEWS
  AMOUNT
  </code></pre>
  
  <p>The data in the <strong>table A</strong>  has the following rows  which is <strong>DateWise</strong>. </p>
  
  <pre><code>20101023  12 1   10000.0 
  20101101  2  4   200.0
  20101114  4  5   -9
  20101201  6  10  150.0 
  20101219  1  12  130.0 
  </code></pre>
  
  <p>My requirement is that i want to write an SQL query that does <strong>monthwise</strong> *<em>report</em>*. For example from webGUI , when i select on the dropdown for month as <strong>DEC</strong> and select year as <strong>2010</strong> . I need to create show the sum of DUR,VIEWS and AMOUNT from <strong>1st of November 2010 to 1st of December 2010</strong>.Any Ideas on how to do it.</p>
  
  <p>The result for DEC2010 should be like below</p>
  
  <pre><code>**DEC2010 12 19 341**
  </code></pre>