CODE EXAMPLE FOR SQL

sql select between two dates

select Date, TotalAllowance from Calculation where EmployeeId = 1
             and Date between '2011/02/25' and '2011/02/27'