selecting potentially duplicate values [message #371801] |
Thu, 07 December 2000 13:45 |
Jerry
Messages: 21 Registered: December 1999
|
Junior Member |
|
|
how do i do this? specifically, say a field is potentially a duplicate if the first 10 characters are the same. how do i set up the sql query to accomadate this? thanks!
|
|
|
Re: selecting potentially duplicate values [message #371813 is a reply to message #371801] |
Sat, 09 December 2000 22:08 |
SQL_Tuner
Messages: 8 Registered: November 2000
|
Junior Member |
|
|
select b1.blah, b2.blah
from blah_table b1, blah_table b2
where substr (upper (b1.blah), 1, 10) = substr (upper (b2.blah), 1, 10)
/
This would be one approach. This will be pretty slow if the table is large, tho. I am assuming that field <blah> is varchar2 and is the column you're searching for possible duplicates. If case is not a concern, you can remove the upper.
Regards,
ST
|
|
|