Join Slack
Communities
Powered by
<@U7Y75N8RG>, distinct on single column is only su...
# exposed
t
tapac
12/29/2017, 9:55 AM
@damian
, distinct on single column is only supported by postgresql (afaik), if you need to select unique item_id, then you may use
FooTable.slice(FooTable.item_id).selectAll().withDistinct()
as
@oshai
stated. In general where is no need to make distinct on one column, in most cases it is replaceable by group by or distinct on row.
3
Views
Open in Slack
Previous
Next