select * from table
where date >= [start date] and date <= [end date]
select * from table
where date between [start date] and [end date]
select * from table
where date >= [start date] and date <= [end date]
select * from table
where date between [start date] and [end date]