Qualify:The SQL Filtering Statement You Never Knew You Needed - Amanda Fioritto

Filtering is a foundational skill in query-building, and it's relatively easy to do for simple to moderately-complex queries. All you need for ungrouped data is a WHERE statement, and a HAVING clause takes care of aggregates: But have you ever tried filtering to deduplicate data using on a window function? Enter QUALIFY: A fast, efficient, readable solution to filtering based on window functions.
Twitter @afioritto; LinkedIn / amandafioritto
normconf.com/