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