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