select field1 from table1 group by field1 having count(field1) > 0 得出table1表中field1字段重复的数据。 如 field1 112 113 124 242 113 124 得出结果为 field1 113 124 转载于:https://www.cnblogs.com/syveen/archive/2006/06/13/425008.html