5.高级过滤

#组合where子句
SELECT prod_id,prod_price,prod_name FROM products WHERE vend_id = “DLL01” AND prod_price <= 4 ORDER BY prod_name;

SELECT prod_name,prod_price FROM products WHERE vend_id = “DLL01” OR vend_id = “BRS01”;
#优先级
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;
#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’;

SELECT prod_name,prod_price FROM products WHERE vend_id IN (‘DLL01’,’BRS01’) AND prod_price >= 10;
#not
SELECT prod_name,prod_price FROM products WHERE NOT vend_id =”DLL01” ORDER BY prod_name;

SELECT prod_name,prod_price FROM products WHERE vend_id <> ‘DLL01’ ORDER BY prod_name;

SELECT prod_name,prod_price FROM products WHERE NOT vend_id IN (‘DLL01’,’BRS01’) AND prod_price >= 5;