3 ms·
You can do that with standard aggregates by comparing min() and max().
by ComodoHacker 3y ago
You can do that with standard aggregates by comparing min() and max().
- masklinn 3y agoIn postgres you can array_agg(distinct) and error on the application side if there is more than one value.
- nerdponx 3y agoOr sometimes you can do something like FIRST() OVER (ORDER BY NULL).
- GolDDranks 3y agoI don't think that errors if the group contains different values...?