MySql SELECT语句执行顺序

SELECT语句 - 执行顺序:
①FROM
②ON
③JOIN<join, left join, right join...>
④WHERE
⑤GROUP BY
⑥HAVING
⑦SELECT
⑧DISTINCT
⑨ORDER BY
⑩LIMIT

posted @ 2021-04-07 20:39  ianunei1998  阅读(142)  评论(0)    收藏  举报