SQL Select的执行顺序

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

posted @ 2014-12-16 11:42  Lucas Luo  阅读(136)  评论(0编辑  收藏  举报