dmrtl-slo

 SELECT SRC_KEY_ASSET_ID , count(*) number_of_duplicates

 FROM z4_rlob_sit4.asset

WHERE SRC_SYSTEM_CODE='DM_RTL_SLO'

  AND SNAPSHOT_DT BETWEEN 20210930 AND 20231130

GROUP BY SRC_KEY_ASSET_ID 

HAVING count(*) > 1;

SELECT * 

FROM z4_rlob_sit4.asset

WHERE SRC_KEY_ASSET_ID = '500000018553749-20231026-23191828890-20231026 14:22:09'

  AND SRC_SYSTEM_CODE='DM_RTL_SLO'

  AND SNAPSHOT_DT=20231031;

SELECT *

FROM z4_rlob_sit4.asset

WHERE SRC_KEY_ASSET_ID IN (

    SELECT SRC_KEY_ASSET_ID

    FROM z4_rlob_sit4.asset

    WHERE SRC_SYSTEM_CODE='DM_RTL_SLO'

    AND SNAPSHOT_DT BETWEEN 20210930 AND 20231130

    GROUP BY SRC_KEY_ASSET_ID

    HAVING count(*) > 1

);

WITH Duplicates AS (

    SELECT SRC_KEY_ASSET_ID

    FROM z4_rlob_sit4.asset

    WHERE SRC_SYSTEM_CODE='DM_RTL_SLO'

    AND SNAPSHOT_DT BETWEEN 20210930 AND 20231130

    GROUP BY SRC_KEY_ASSET_ID

    HAVING count(*) > 1

)

SELECT *

FROM z4_rlob_sit4.asset

WHERE SRC_KEY_ASSET_ID IN (SELECT SRC_KEY_ASSET_ID FROM Duplicates);