SELECT, FROM, ORDER BY
SELECT prod_id, prod_price, prod_name
FROM Products
ORDER BY 2, 3;
关键字一般大写
ORDER BY 2, 3; 可以按照所选取列进行排序
WHERE
SELECT prod_name, prod_price
FROM Products
WHERE prod_price = 3.49;
tip: 同时使用WHERE和ORDER BY, 应让ORDER BY 在WHERE 之后
范围查询BETWEEN AND
SELECT prod_name, prod_price
FROM Products
WHERE prod_price BETWEEN 5 AND 10;
与WHERE组合: AND, OR, IN, NOT
以IN为例:
SELECT prod_name, prod_price
FROM Products
WHERE vend_id IN ( 'DLL01', 'BRS01' )
ORDER BY prod_name;
实际上，IN与OR功能一致，但更清晰
通配符
LIKE: 匹配操作符，后跟格式字符串
%: 表示任何字符出现任意次 数
SELECT prod_id, prod_name FROM Products WHERE prod_name LIKE 'Fish%';输出：
prod_id prod_name ------- ------------------ BNBG01 Fish bean bag toy_: 只匹配单个字符
[]: 指定一个字符集, 匹配方括号中任意一个字符，它也只能匹配单个字符。
SELECT cust_contact FROM Customers WHERE cust_contact LIKE '[JM]%' ORDER BY cust_contact;输出▼
cust_contact ----------------- Jim Jones John Smith Michelle Green