On 2019-03-12 13:13, Michal Kurczabinski michk...@gmail.com [firebird-support] wrote: > I forgot about very useful feature lile FILTER on window functions > select some_col, count(other_col) over() FILTER ( where other_col > > soime_val) Maybe in FB 4.0 it might be implemented
FILTER has been implemented in Firebird 4. See "FILTER Clause for Aggregate Functions" in the Firebird 4 beta 1 release notes, or http://tracker.firebirdsql.org/browse/CORE-5768 Note though that the order you mention is not right, it right order would be count(other_col) filter (where other_col > soime_val) over(), or filter-clause before window-clause(that is also the order in PostgreSQL). Mark