如何检索出在某个字段上相同的记录？

[newline]

要检索出table1上col1字段上相同的记录，SQL如何写？

[victorycyz]

select a.*
from table1 a join
( select col1
from table1
group by col1
having count(*)>1
) b
on a.col1=b.col1

[newline]

谢谢！

[qiaolin53]

select column,coount(*) from table1
group by column
having count(*)>1

[qqba]

select * from table1 a where a.id!=(select max(id) from table b where a.coll=b.coll)