title: Sum of Particular Column in sql by selecting from date and to date
body: <p>The table structure I currently have is like this:</p>
  
  <pre><code>Category   Date        GrandTotal
  -----------------------------------    
  Cat1       26/2/2013      900
  Cat1       26/2/2013      200
  Cat2       26/2/2013      100
  Cat2       27/2/2013      150
  Cat2       28/2/2013      200
  </code></pre>
  
  <p>But I'm looking to get it like this:</p>
  
  <p>If I select the Transaction from <code>26/2/2013</code> to <code>26/2/2013</code></p>
  
  <p>I should get the total amount for <code>26th February</code> only, so the result should be 1200.</p>
  
  <p>Can any one please tell me the SQL query for this?</p>