SQL语句的执行顺序是什么?

一、样例SQL

SELECT
ENAME,MAX(SAL) AS MAX_SAL
FROM EMP
WHERE ENAME IS NOT NULL
GROUP BY ENAME
HAVING MAX(SAL) > 1000
ORDER BY MAX_SAL

二、执行顺序
1、FROM
2、WHERE
3、GROUP BY
4、MAX
5、HAVING
6、ORDER BY

posted @ 2020-02-03 02:35  renguanyu  阅读(389)  评论(0)    收藏  举报