sql 查询表中相同的列

select * from fenlei where bieming in (select bieming from fenlei group by bieming having count(*)>1 ) --全部相同的列

select * from fenlei m where id not in (select min(id) from fenlei n where m.bieming = n.bieming)   --id最新的相同的列