查询字段相同的值

select * from 表 where b in (select b from 表 group by b having count(*)>1)
以上，希望对你有所帮助！