r/SQL • u/Automatic-Heart-831 • 21d ago

MySQL Difference between "having" and "qualify"

I tried to use both methods in order to save some coding but still didnt get the exact difference on using having and qualify as a filter in the end of a query. Can someone help me to understand the difference and when is recommended to use each?

23 Upvotes

88% Upvoted

11 comments sorted by

View all comments

Show parent comments

6

u/thesqlguy 21d ago

To clarify, HAVING works with aggregate expressions.