title: Date range in sql
body: <p>I want to write a query where it displays data between 01-April-2010 to lastday-april-2011. </p>
  
  <p>But I don't want to hard code the year.  It should take from system date so it only displays records from this year april to next year april. </p>
  
  <p>Thanks in advance for the help.</p>