Порядок выполнения SQL

FROM
ON
JOIN
WHERE
GROUP BY
WITH CUBE or WITH ROLLUP
HAVING
SELECT
DISTINCT
ORDER BY
TOP / LIMIT

https://docs.microsoft.com/en-us/sql/t-sql/queries...

Для MySQL

FROM clause
WHERE clause
SELECT clause
GROUP BY clause
HAVING clause
ORDER BY clause

Заметка
comments powered by Disqus