Comment by dotancohen
Comment by dotancohen 9 hours ago
Without DISTINCT ON (which I've never used) you can use a window function via the OVER clause with PARTITION BY. I'm pretty sure that's standard SQL.
Comment by dotancohen 9 hours ago
Without DISTINCT ON (which I've never used) you can use a window function via the OVER clause with PARTITION BY. I'm pretty sure that's standard SQL.
Yes, this is the implementation I have seen in other dialects.