title: java financial year wise sum Of Amount
body: <p>I am stuck with a query to fetch sum of transaction amount financial year wise.
  My table is </p>
  
  <pre><code>TXN_DATE    TXN_AMOUNT
  12/01/2014  100
  12/08/2014  200
  12/01/2015  300
  12/04/2015  400
  12/04/2013  500
  </code></pre>
  
  <p>I want the result to be displayed as</p>
  
  <pre><code>FinYear         Amount
  2013-2014       600
  2014-2015       500
  2015-2016       400
  </code></pre>
  
  <p>Considering financial year duration from 1st April of an year to 31st March of next year.</p>
  
  <p>Databse DB2</p>
  
  <p>Date is timestamp in database and date format specified in the example is dd/MM/yyyy</p>