Execution sequence of Group By, Having and Where clause

Execution sequence of Group By, Having and Where clause in SQL

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

Last Updated: August 31, 2017