http://msdn.microsoft.com/en-us/library/ms189499(v=SQL.100).aspx
1.FROM
2.ON
3.JOIN
4.WHERE
5.GROUP BY
6.WITH CUBE or WITH ROLLUP
7.HAVING
8.SELECT
9.DISTINCT
10.ORDER BY
11.TOP
这篇有例子https://blog.csdn.net/u013887008/article/details/93377939