Resources

FILTER Clause

duckdb.org

The FILTER clause may optionally follow an aggregate function in a SELECT statement. This will filter the rows of data that are fed into the aggregate function in the same way that a WHERE clause filters rows, but localized to the specific aggregate function. FILTERs are not currently able to be used when the aggregate function is in a windowing context. There are multiple types of situations where this is useful, i…

Visit Site

Resources duckdb.org