Stefan Stefanov writes:
> Gents, I have a suggestion for DISTINCT ON clause syntax.
>DISTINCT ON (expression(s) [ORDER BY expression(s)])
> Determines the precedence within each DISTINCT ON group (i.e. the ‘first’ row
> to be picked)
> Motivation
> • Using the query-wide ORDER BY clause to
Gents, I have a suggestion for DISTINCT ON clause syntax.
DISTINCT ON (expression(s) [ORDER BY expression(s)])
Determines the precedence within each DISTINCT ON group (i.e. the ‘first’ row
to be picked)
Motivation
• Using the query-wide ORDER BY clause to determine which record to pick m
