Re: Limiting results in a joined table
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.
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.