select * from orderswhere orderdate betwwen '1997-01-01' and '1997-01-31'如果要去掉边界值就用andselect * from orders where orderdate > '1997-01-01' and orderdate < '1997-01-31'
select * from table where date betwwen startdate and enddate