表:TEMP_CUSTG_IMPORT_DETAIL
查重字段:CONTACT_NAME、IDEN_NUM
根据某一条记录的两个字段查询表中重复记录
方法一:IN
SELECT *
FROM TEMP_CUSTG_IMPORT_DETAIL A
WHERE (A.CONTACT_NAME, A.IDEN_NUM) IN
(SELECT CONTACT_NAME, IDEN_NUM
FROM TEMP_CUSTG_IMPORT_DETAIL
WHERE ID = '201904190000000760')
方法二:EXISTS
SELECT *
FROM TEMP_CUSTG_IMPORT_DETAIL T
WHERE EXISTS (SELECT A.ID
FROM TEMP_CUSTG_IMPORT_DETAIL A
WHERE A.CONTACT_NAME = T.CONTACT_NAME
AND A.IDEN_NUM = T.IDEN_NUM
AND A.ID = '201904190000000760')