查询ceshi1027表中obj_id重复的数据记录: SELECT s.OBJ_ID,count(OBJ_ID) count FROM `ceshi1027` s group by OBJ_ID having count>1