1select Date, TotalAllowance from Calculation where EmployeeId = 1
2 and Date between '2011/02/25' and '2011/02/27'
3
1/*the BETWEEN operator is used to filter the result set within
2a certain range. the values can be numbers, texts or dates */
3SELECT column_name(s)
4FROM table_name
5WHERE column_name BETWEEN value1 AND value2;
1SELECT column_name(s)
2FROM table_name
3WHERE column_name BETWEEN value1 AND value2;
1SELECT * FROM [table]
2WHERE [time] >='2014-04-08 23:53:00.000' AND [time] <= '2014-04-08 23:58:00.000'
3