agershun/alasql

FILTER notation for aggregate functions

mathiasrw asked for this feature about 3 years ago — 1 comment

mathiasrw commented about 3 years ago Admin

The filter clause follows an aggregate function:

SUM() FILTER(WHERE ) With the exception of subqueries and window functions, the may contain any expression that is allowed in regular where clauses0.

http://modern-sql.com/feature/filter

Join the discussion!

Sign-in with GitHub to comment