【PostGresql】------- 通过sql查找重复数据代码实例

1.按多个字段查询:

select "POSITION_NAME","CMEMO","SUPERINTENDENT_MAN_NAME","SUPERINTENDENT_MAN_NAME" from  "DCS_RISK"
where ("POSITION_NAME","CMEMO") in (select  "POSITION_NAME","CMEMO" from   "DCS_RISK"   group by "POSITION_NAME","CMEMO"    having count (*) > 1) ORDER BY "POSITION_NAME" DESC,"CMEMO" DESC

1.按单个字段查询:

select "POSITION_NAME","CMEMO","SUPERINTENDENT_MAN_NAME","SUPERINTENDENT_MAN_NAME" from  "DCS_RISK"
where "ID" in (select  "ID" from   "DCS_RISK"  group by "ID"    having count ("ID") > 1)