Snowflake
Published in

Snowflake

Snowflake QUALIFY Clause

Photo by Nathan Dumlao on Unsplash

In this blog we are going to see how we can utilize the magic of qualify clause to reduce the overhead of an extra layer of query to filter certain sets of data.

Hope you all are aware of Having Clause which we have quite frequently used in ANSI SQL to filter the records in Group By clause for aggregated data.

Similarly, qualify is the way to filter the records in window functions like…

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Rajiv Gupta

Rajiv Gupta

Sr. Architect at Cognizant, Snowflake Data Super Hero, Snowflake SME