I'm not clear which rows are duplicates.
It looks like limb_id, branch_id and twig_id make up a unique key.
If there was a row (2, 2, 7,103.7) would it be a duplicate of rows
(1,1,2,103.7) and (1,1,3,103.7)?
--
MIke Nolan
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
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
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
illustrate with a simple example...
We'll talk about deleting leaves on a tree where
