理解Sql语句

SQL 语句的语法顺序和其执行顺序完全不一样，其执行顺序为：
FROM
WHERE
GROUP BY
HAVING
SELECT
DISTINCT
UNION
ORDER BY
摘自：http://blog.jobbole.com/55086/