1 查询一个字段相同的所有记录
TableA ,name,number
select TableA.name from TableA inner join (select number from TableA group by number having count(number)>1) TableB on TableA.number=TableB.number.
1 查询一个字段相同的所有记录
TableA ,name,number
select TableA.name from TableA inner join (select number from TableA group by number having count(number)>1) TableB on TableA.number=TableB.number.