SQL（4）- 过滤数据

where 过滤数据，条件筛选

1. select prod_price from products where prod_price=199;
2. select prod_price from products where prod_price<199 order by prod_price; order by（排序）要在where（筛选）之后。
3. select prod_name from products where prod_name!=apple;
4. elect prod_price from products where prod_price between 199 and 499;
5. select prod_price from products where prod_price is null;

null值和0、空字符串、空格不同。

《SQL必知必会》-学习记录。