利用SQL找出同一Table重覆的值

SELECT col1, col2, count(*) FROM t1 GROUP BY col1, col2  HAVING count(*) > 1;
SELECT * FROM t1 a where a.rowid > (SELECT min(b.rowid) FROM t1 b WHERE b.col1=a.col1);

以上兩種SQL都可以。