selectDistinct
The selectDistinct method creates a new table containing all of the unique values for a set of key columns.
When the selectDistinct method is used on multiple columns, it looks for distinct sets of values in the selected columns.
Syntax
Parameters
| Parameter | Type | Description |
|---|---|---|
| columns | String... | Key columns from which distinct values will be selected. |
| columns | Selectable... | Key columns from which distinct values will be selected. |
| columns | Collection<? extends Selectable> | Key columns from which distinct values will be selected. |
Returns
A new table containing all of the unique values for a set of key columns.