MySQL Forums
Forum List  »  Newbie

Re: Limiting results in a joined table
Posted by: Barry Galbraith
Date: July 14, 2015 07:15PM

Use SELECT col1, col2 ... instead of SELECT *
If you name only cols that will produce rows that are totally identical, the DISTINCT will remove the duplicates.

SELECT * is returning rows where 'episode1' is duplicated, but other columns in the row are different so DISTINCT can't cull them.

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Limiting results in a joined table
July 14, 2015 07:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.