查询某表某列数据相同列>1的记录
select columnName from tableName where columnName in (select columnName from tableName group by columnName having count(*) >1)
select columnName from tableName where columnName in (select columnName from tableName group by columnName having count(*) >1)