sql 查询 货币问题
在ACCESS中
有个货币字段
money
我要搜索 价格在 5-10的查询语句该怎么写?~
[解决办法]
where money between 5 and 10
[解决办法]
select * from table1 where 5<money<10
[解决办法]
[解决办法]
[解决办法]
[解决办法]
up
[解决办法]
where [money] between 5 and 10
[解决办法]
where money > 5 and money < 10
[解决办法]