Re:Distinct on: a confusing, unique and useful feature in Po...
by zeroimpl on Saturday March 21, 2020 @08:50PM
(#22651643)
kinda. You can use aggregates as window functions, but cannot use window functions as aggregates.
So it would be:
select a, last_value(b) over(partition by a), last_value(c) over(partition by a) from table
Note the lack of a "GROUP BY" so this will result in duplicates unless you add a DISTINCT.
https://www.postgresqltutorial.com/postgresql-last_value-fun...