Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
SQL:2003 introduced the FILTER clause, which extends aggregate functions with a WHERE clause.
This is supported by PostgreSQL, SQLite and a MySQL extension.
See https://modern-sql.com/feature/filter#conforming-alternatives for details.