区间查询sql

[「已注销」]

我需要查询一段时间的数据怎么写sql语句
比如要查3.1号到3.30号数据 sql语句是什么？

[li4c]

楼上都是正解

[hhhttt_]

select * from tab where [col] between 'time1' and 'time2'

[唐诗三百首]

select * from [表名] where [日期字段] between '2016-03-01' and '2016-03-30'

[範先森]

像时间啊数字啊这些能比较的都可以用between and，当然你也可以直接用<或>，[datatime]>'2016-03-01' and [datatime]<'2016-03-20'