This lesson is for subscribers
You've completed the free preview. Subscribe to unlock every lesson in every course.
Lesson 1011 of 2,145·26. Advanced SQLPro lesson
Filtering on Window Function Results
Using subqueries or CTEs to filter rows based on window function output, since WHERE cannot reference them.