Étiqueté : DOUBLON

[SQL] – Requete pour trouver les doublons 0

[SQL] – Requete pour trouver les doublons

Exemple : select count(*) as DOUBLON ,ASSETID , ASSETID from ASSET T1 where ASSETID in( SELECT ASSETID FROM ASSET T2 where T1.ASSETNUM=T2.ASSETNUM GROUP BY ASSETID , ASSETNUM HAVING COUNT(*) > 1 ) group by...