SQL 语句的执行顺序跟其语句的语法顺序并不一致
一般而言
SQL 语句的语法顺序是:
1.SELECT[DISTINCT]2.FROM
3.WHERE4.GROUP BY5.HAVING6.UNION7.ORDER BY
其执行顺序为:1FROM,2WHERE3.GROUP BY4.HAVING5.SELECT6.DISTINCT
7.UNION8.ORDER BY
SQL 语句的执行顺序跟其语句的语法顺序并不一致
一般而言
SQL 语句的语法顺序是:
1.SELECT[DISTINCT]2.FROM
3.WHERE4.GROUP BY5.HAVING6.UNION7.ORDER BY
其执行顺序为:1FROM,2WHERE3.GROUP BY4.HAVING5.SELECT6.DISTINCT
7.UNION8.ORDER BY