abenevaut · April 5, 2024 10:46 · abenevaut · Apr 5, 2024
diff --git a/# Find duplicate rows in SQL table.md b/# Find duplicate rows in SQL table.md
diff --git a/find.sql b/find.sql
 SELECT DISTINCT *
 FROM table t1
 WHERE EXISTS (
  SELECT *
  FROM table t2
  WHERE t1.id <> t2.id
    AND   t1.siret = t2.siret
 )
	SELECT DISTINCT *
	FROM table t1
	WHERE EXISTS (
	SELECT *
	FROM table t2
	WHERE t1.id <> t2.id
	AND t1.siret = t2.siret
	)