All pastes #903792 Raw Edit

Untitled

public text v1 · immutable
·published 2008-02-14 14:12 UTC
rendered paste body
#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 - ?