Jul 20, 2015

What is the 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

No comments:

Post a Comment