On Tue, Mar 22, 2022 at 3:39 PM David Rowley <dgrowle...@gmail.com> wrote:
> 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. > > I'd like some of that syntactic sugar please. It goes nicely with my HAVING syntactic coffee. David J.
