1. FROM
2. ON
3. JOIN
4. WHERE
对元组的限制条件
5. GROUP BY
分组方式
6. WITH CUBE or WITH ROOLUP
7. HAVING
对分组的限制条件
8. SELECT
9. DISTINCT
SELECT COUNT(DISTINCT ID) FROM teachers WHERE semester = 'Spring' and year=2010;
SELECT DISTINCT column_name, column_name FROM table_name;
10.ORDER BY
11.TOP