Jump to content

Archived

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

dstaton

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.

Share this post


Link to post
Share on other sites
ON SOUNDEX(a.programme_name) = SOUNDEX(b.programme_name)

...or (in 4.1.0+)...

ON a.programme_name SOUNDS LIKE b.programme_name

Share this post


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.

Share this post


Link to post
Share on other sites

Hmm, looks like Oracle's implementation of SOUNDEX leaves a bit to be desired

Share this post


Link to post
Share on other sites

×
×
  • 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.