i don't know whetheryou are looking for this
create table tea(id number(40),f_name varchar2(150));
INSERT INTO tea ( ID, F_NAME ) VALUES (
832, 'Magnolia St. #12');
INSERT INTO tea ( ID, F_NAME ) VALUES (
832, 'Magnolia St. #10');
INSERT INTO tea ( ID, F_NAME ) VALUES (
1909, ' Delaware Ave.');
INSERT INTO tea ( ID, F_NAME ) VALUES (
1909, 'Delaware St.');
INSERT INTO tea ( ID, F_NAME ) VALUES (
832, 'Mangolia');
INSERT INTO tea ( ID, F_NAME ) VALUES (
832, 'Monolia');
INSERT INTO tea ( ID, F_NAME ) VALUES (
1909, 'Delaware');
INSERT INTO tea ( ID, F_NAME ) VALUES (
1909, 'Mandea');
commit;
select * from tea order by id;
select f_name from tea where upper(f_name) like upper('d%') and id=1909
select * from tea /* for finding duplicates*/
where id=832 and rowid not in (select min(rowid)
from tea group by id);
2009/3/14 Rick <[email protected]>
>
> Hi,
> I have table Customer and I want to be able to find any duplicates or
> anything that looks like duplicates from the Address_1 column and from
> the same table. I would want to be able to identify similar addresses.
> For example;
>
> 1909 Delaware Ave.
> 1909 Delaware St.
>
> or
>
> 832 Magnolia St. #12
> 832 Magnolia St. #10
>
>
> Using SQL, Can I come up with some Like statement with wildcard
> characters? If so, how?
>
> Thanks in advance.
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
