sql选取相同的行

Question

一个表有50万行
怎么选取相同的行？

select * from table1 a where (select count(1) from table1 where col1=a.col1)>1

太慢了，好久了还木有出来~
求招式阿~

Answer 1

试试这个呢
SELECT * FROM table GROUP BY col HAVING count(col)>1