[SQL] – Requete pour trouver les doublons

Requête permettant de trouver les doublons des actifs:

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;