Jump to content

Find Duplicate Entries in Table

Recommended Posts

ARGGGG!!!!  I am destined to never get this query to work.  I never dreamed it would be this difficult.


When running:


SELECT a.title_id as ida, a.programme_name as titlea, a.year_of_production as yeara,

        b.title_id as idb, b.programme_name as titleb, b.year_of_production as yearb

        FROM title a INNER JOIN title b

        ON SOUNDEX(a.programme_name = b.programme_name)

        WHERE a.title_id < b.title_id


I get ORA-00907: missing right parenthesis.  This is the error I was getting with the query I tried back on May 4th.

Link to post
Share on other sites

Same results as before...it returns over 30,000 records.  I am not getting results that closely match.


Example:  Brotherhood of Justice = Border, The

              Eating Raoul = Eyewitness


I don't think the soundex thing is working for what I need.

Link to post
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.