Is it ever useful to SELECT DISTINCT on the primary key column(s)? From my understanding, primary keys are unique by definition. If that's true, would one ever want to SELECT DISTINCT on the primary key? Is this ever practical/useful?
If you join with another m:n table that duplicates the PK value in your result set, then it would be useful.