Re: SQL select and Oracle software

Another solution which enables you to directly delete the duplicates:

delete from table t1
where rowid > (select rowid from table t2 where t2.column=t1.column);

Hope this helps,

Pavel

Dave Angalich <dangalich_at_nttc.edu> wrote in article <34BFD6E0.AA3E7955_at_nttc.edu>...
> We have recently combined 10+ different client databases into 1 large
> database. This along with CSR entry has led to duplicate/erroneous
> records. What I need to do is find a good way/tool to list and remove
> the possible duplicates and update the necessary key/foreign key
> ingo.(ex. List all people with the same last and first names and city
> and pick which ones are dups. The picking can be manual.)
>
> Does anybody know of such a tool?? If not can you think of an efficient
> way in SQL to list these dups?
>
> Thanks in advance,
> Dave Angalich
>
>
Received on Mon Jan 19 1998 - 00:00:00 CST