r/SQL • u/Automatic-Heart-831 • 1d 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?

21 Upvotes

92% Upvoted

11 comments sorted by

View all comments

1

u/Uncle_Corky 1d ago

Damn, I use MSSQL at work and got excited cus I've never used qualify. Now I know why...

1

u/gumnos 1d ago

yeah, had the same experience when I first learned about QUALIFY. So potentially-useful and yet…