i am developing a leave application,i want to retrive the days from march to april.
i am having a lot of records in the database,for example if the employee 001 has taking leave from march 3rd to march 9,2012,i used to write the query as
select sum(pl) as totaldays form employee where empid='001'and tdate between '2013-03-31'
it will be retrived properly...but how can i retrive the employee records every year between april 2012 to march 2013 employee records only,
because every april for all the employee pl leave is increased to 30,after april i want to skip the april2012 to march 2013 records for all the employee,only i want to consider april 2013 to march 2014 like that only i want..if u have any better idea pls tel me