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
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