SQL Order of Operation

preview_player
Показать описание
The order of your SELECT statement is not what you think it is. It's actually...
FROM
WHERE
GROUP BY
HAVING
SELECT
ORDER
Рекомендации по теме
Комментарии
Автор

The real question is, why does any clause after a JOIN still require column qualifiers (table.column) as if those clauses are still referring to distinct tables?

bquimby
Автор

Where does the "limit/ top" fit in?

vaibhavchhabra