[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 ASSETID , ASSETNUM;
![[MAXIMO] – Procédure de la création des SETS – ORG – SITES](http://maximo4you.fr/wp-content/themes/hueman/assets/front/img/thumb-medium-empty.png)
Commentaires récents