Execution sequence of Group By, Having and Where clause in SQL Server?
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
No comments:
Post a Comment