酿豆腐泡的家常做法:sql中可以使用 多个between and语句吗?
来源:百度文库 编辑:杭州交通信息网 时间:2024/06/03 01:18:33
sql中可以使用 多个between and语句吗?
例如:select * from db
where id between 1 and 10
or id between 50 and 100;
例如:select * from db
where id between 1 and 10
or id between 50 and 100;
应该可以
自己试下不就得了
可以
可以.譬如:
select * from mms where (age between 15 and 50) and (weight between 90 and 100)
肯定没问题
可以的我试过了