Select语句的处理顺序

•1.FROM
•2.ON
•3.JOIN
• 4.WHERE
• 5.GROUP BY
• 6.WITH CUBE 或 WITH ROLLUP
• 7.HAVING
• 8.SELECT
• 9.DISTINCT
• 10.ORDER BY
• 11.TOP
posted @ 2011-04-03 13:22    阅读(189)  评论(0编辑  收藏  举报