Re: Need efficient way to remove (almost) duplicate rows from a table

2023-10-17 Thread Paul Jungwirth
On 10/17/23 15:48, David Gauthier wrote: I have a table with millions of records and there are a lot of "almost" duplicates that I want to get rid of in an efficient way.  Best to illustrate with a simple example... This sounds like a classic use-case for a "correlated subquery". Assuming you

Re: Need efficient way to remove (almost) duplicate rows from a table

2023-10-17 Thread Ron
https://dba.stackexchange.com/a/138327/63913 On 10/17/23 17:48, David Gauthier wrote: v11.5 on linux (I know, I know, IT is working on the upgrade to 15.2) I have a table with millions of records and there are a lot of "almost" duplicates that I want to get rid of in an efficient way.  Best to