颖儿明道:sql中可以使用 多个between and语句吗?
来源:百度文库 编辑:高考问答 时间:2024/05/03 00:30:54
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)
肯定没问题
可以的我试过了