Untitled
public text v1 · immutable#I'm running the following query:
SELECT * from track JOIN artist ON track.artist=artist.id where artist.name = 'Pink Floyd';
#and I'm getting the following result snippet:
id artist name
8232 191 Astronomy Domine
2341 191 Wish You Were Here
9871 191 Wish You Were Here
...
#So I get a lot of results, but some names are not distinct, e.g.
the Wish You Were Here title;
#I'd like to only see what unique names are there - ?