SQL学习笔记-范围查找（BETWEEN）

使用between的语法格式

SELECT name,price FROM goods where price BETWEEN 45 AND 60;                                            

结合order by排序某范围内的数据                       

SELECT id ,name,price FROM
goods where price BETWEEN 45 AND 60 ORDER BY price DESC;

    注意：order by需要是最后的语句

not between 查询不在某范围内的数据

SELECT id ,name,price FROM goods where price  NOT BETWEEN 45 AND 60;

Between与逻辑运算符结合运用

SELECT * FROM goods where sales  BETWEEN 200 AND 300 AND price BETWEEN 45 AND 60;                                                                             

BETWEEN和操作符in/not in的混合用法 

SELECT * FROM goods where company IN('公司A','公司B') AND price BETWEEN 45 AND 60;

BETWEEN和通配符like的混合用法  

SELECT * FROM goods where name like '商%' AND price BETWEEN 45 AND 60;