sql - SQL Server中Group By、Having和Where子句的执行顺序？

Question

当我们将GROUP BY和HAVING与WHERE子句一起使用时，我只是对SQL查询的执行顺序感到困惑。哪个先被处决？顺序是什么？

Answer 1

按顺序:

FROM & JOINs determine & filter rows
WHERE more filters on the rows
GROUP BY combines those rows into groups
HAVING filters groups
ORDER BY arranges the remaining rows/groups
LIMIT filters on the remaining rows/groups