查询数据库表中某个字段值有重复的记录
话不多说,直接上代码吧
select ORG_CODE, count(id) from CARCTRL.CTRL_UNUSUAL_INFO group by ORG_CODE HAVING count(id) > 1;
话不多说,直接上代码吧
select ORG_CODE, count(id) from CARCTRL.CTRL_UNUSUAL_INFO group by ORG_CODE HAVING count(id) > 1;