FlashcardAdvanced
Filtering on Window Function Results
You cannot use a window function in WHERE; wrap it in a subquery or CTE first.
Question
Why can't you filter a window function result in the WHERE clause, and how do you work around it?
Click to reveal answer