1、 WHERE子句
SELECT prod_name, prod_price
FROM Products
WHERE prod_price = 3.49;
2、WHERE子句操作符
(1)检查单个值
SELECT prod_name, prod_price
FROM Products
WHERE prod_price < 10;
(2)不匹配检查
SELECT vend_id, prod_name
FROM Products
WHERE vend_id <> 'DLL01'; --供应商ID不等于DLL01
(3)范围值检查
SELECT prod_name, prod_price
FROM Products
WHERE prod_price BETWEEN 5 AND 10;
(4)空值检查
SELECT prod_name
FROM Products
WHERE prod_price IS NULL;