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)