- 查询某一字段中重复的数据
select t.* from TableName t where t.fieldname in (select a.fieldname from TableName a group by a.fieldname having count(a.fieldname)>1)
select t.* from TableName t where t.fieldname in (select a.fieldname from TableName a group by a.fieldname having count(a.fieldname)>1)