cedricAbonnel/varlog

Files

T

Cédrix b0716911b3 init : articles varlog (migration depuis rsync)

2026-05-15 10:37:48 +02:00

714 B

Raw Permalink Blame History

Trouver les doublons


SELECT   COUNT(*) AS nbr_doublon, champ1, champ2, champ3
FROM     table
GROUP BY champ1, champ2, champ3
HAVING   COUNT(*) > 1


SELECT DISTINCT *
FROM table t1
WHERE EXISTS (
              SELECT *
              FROM table t2
              WHERE t1.ID <> t2.ID
              AND   t1.champ1 = t2.champ1
              AND   t1.champ2 = t2.champ2
              AND   t1.champ3 = t2.champ3 )