设表名为X,字段为C1,C2,C3,.... 做一下查询： select count(*),c1,c2,c3,.... from X group by c1,c2,c3.... having count(*)>1 SELECT COUNT(*) AS RowNumber,COL1,COL2 FROM TABLE1 T1 WHERE (SELECT COUNT(*) FROM TABLE1 T2 WHERE T1.COL1 = T2.COL1 AND T1.COL2 = T2.COL2)&