[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;
![[MIF] – Importer les classifications dans Maximo via le MIF – Episode 1/3](http://maximo4you.fr/wp-content/themes/hueman/assets/front/img/thumb-medium-empty.png)
Commentaires récents