【SQL必知必会】03.过滤数据（零基础自学笔记）

 

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;