sql 查询 货币问题
在ACCESS中
 有个货币字段
  money

我要搜索 价格在 5-10的查询语句该怎么写？~

------解决方案--------------------
where money between 5 and 10
------解决方案--------------------
select * from table1 where 5<money<10
------解决方案--------------------

探讨

where money between 5 and 10

------解决方案--------------------

探讨

select * from table1 where 5 <money <10

------解决方案--------------------

探讨

引用:
where money between 5 and 10

------解决方案--------------------
up
------解决方案--------------------

where [money] between 5 and 10

------解决方案--------------------
where money > 5 and money < 10
------解决方案--------------------

探讨

where [money] between 5 and 10