一些SQL--高级数据过滤

Server version: 5.6.47 MySQL Community Server (GPL)

1.AND操作符
SELECT prod_id,prod_price,prod_name FROM Products WHERE vend_id='DLL01' AND prod_price<=4;


2.OR操作符
SELECT prod_name,prod_price FROM Products WHERE vend_id='DLL01' OR vend_id='BRS01';

3.求值顺序
SELECT prod_name,prod_price FROM Products WHERE vend_id='DLL01' OR vend_id='BRS01' AND prod_price>=10;

SELECT prod_name,prod_price FROM Products WHERE (vend_id='DLL01' OR vend_id='BRS01') AND prod_price>=10;

4.IN操作符
SELECT prod_name,prod_price FROM Products WHERE vend_id IN ('DLL01','BRS01') ORDER BY prod_name;

SELECT prod_name,prod_price FROM Products WHERE vend_id='DLL01' OR vend_id='BRS01' ORDER BY prod_name;

5.NOT操作符
SELECT prod_name FROM Products WHERE NOT vend_id='DLL01' ORDER BY prod_name;

SELECT prod_name FROM Products WHERE vend_id <> 'DLL01' ORDER BY prod_name;

©著作权归作者所有,转载或内容合作请联系作者
平台声明：文章内容（如有图片或视频亦包括在内）由作者上传并发布，文章内容仅代表作者本人观点，简书系信息发布平台，仅提供信息存储服务。

推荐阅读更多精彩内容