Access between and 用法,我想用between and来查询数据库当前时间到前面7天的数据,你能帮我下

来源：学生作业帮编辑：大师作文网作业帮分类：综合作业时间：2024/11/18 07:22:25

Access between and 用法,我想用between and来查询数据库当前时间到前面7天的数据,你能帮我下吗?

select * from 表名 where 时间字段 between date()-7 and date()
这样?表名和时间字段替换成你自己的
再问：扣扣给我讲下吧：）384194297

between----and的用法 between and的用法 sql between and informix数据库和其他的一样么? Access中“between 20 and 50 ”和“>=20 and 请问,数据库中 and能用在 between and后面吗 between and 和between with的区别为什么说ACCESS里,“"ABC" BETWEEN"A"AND"B"的值为TRUE "ABC" BETWEEN"A"A SQL语言中,条件年龄BETWEEN AND的用法请帮我翻译,"Between labor and play stands work." between连接的是什么词?比如：He sits between you and ( ) 他坐在你和我的中间. 用range between ...and...造句帮我写一篇Relationship between love and marriage的英语作文