On Thu, 17 Mar 2022 at 17:04, Corey Huinker <corey.huin...@gmail.com> wrote: > It seems like this effort would aid in implementing what some other databases > implement via the QUALIFY clause, which is to window functions what HAVING is > to aggregate functions. > example: > https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#qualify_clause
Isn't that just syntactic sugar? You could get the same from adding a subquery where a WHERE clause to filter rows evaluated after the window clause. David
