1.查看表数据 表中BANKORGCODE+ SUBMITDATE+CURRENCYCODE 字段在表中唯一
2. 根据group by进行对三个字段进行分组,分组之后count(1)进行求和。求和是三个字段分组之后的求和,即屁+大屁+臭屁是一组,统计你总共放了几个屁+大屁+臭屁。。。得到求和大于1的BANKORGCODE+ SUBMITDATE+CURRENCYCODE字段
SELECT BANKORGCODE, SUBMITDATE, CURRENCYCODE
FROM T_RCPMIS_2126_01_JWGRJNZHYEXX
GROUP BY BANKORGCODE, SUBMITDATE, CURRENCYCODE
HAVING count(1) > 1
3.根据inner join 或者 join 得到字段条件,主表的条件是子表查询的字段结果。即,根据子表查询的三个字段作为条件进行筛选,存在多少组屁是大于1的,即非唯一的。查出表中的所有符合条件的数据
SELECT *
FROM T_RCPMIS_2126_01_JWGRJNZHYEXX t1
INNER JOIN (SELECT BANKORGCODE, SUBMITDATE, CURRENCYCODE
FROM T_RCPMIS_2126_01_JWGRJNZHYEXX
GROUP BY BANKORGCODE, SUBMITDATE, CURRENCYCODE
HAVING count(1) > 1) T
ON T.BANKORGCODE = t1.BANKORGCODE
AND T.SUBMITDATE = t1.SUBMITDATE
AND T.CURRENCYCODE = t1.CURRENCYCODE