Re: Partial Mode in Aggregate Functions - Mailing list pgsql-hackers

with Data as (select V from MyTable where F1 = 100)

select (select jsonb_agg(V) from Data) Total,
       (select jsonb_agg(V) from Data where V>1) Filtered;