withDistinctOn
Specifies that the SELECT query should retrieve distinct results based on the given list of columns.
This method can be used to set a DISTINCT ON clause for the query, which is supported by some SQL dialects (e.g., PostgreSQL, H2). The resulting query will retrieve rows that are distinct based on the specified columns.
Return
The current Query instance with the DISTINCT ON clause applied.
Parameters
columns
The columns to apply the DISTINCT ON clause.