[SQL] – Query to find duplicates

Example : select count(*) as DUPLICATE ,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...