Posts by matthewbadger@fosstodon.org
 (DIR) Post #AWUbTyuXW4ociIaRlo by matthewbadger@fosstodon.org
       2023-06-08T20:29:24Z
       
       0 likes, 0 repeats
       
       @simon most dialects don’t support filter (only Postgres and SQLite, as far as I’m aware). You can achieve the same with instead of count + filter, you add an ‘is new group’ column which casts the filter condition to an int. Then add another CTE with sum(is new group) over (blah).