select a.* from tb a join (select f_prehousecode from tb group by f_prehousecode having count(1)>1) b on a.f_prehousecode=b.f_prehousecode
34,571
社区成员
254,582
社区内容
加载中
试试用AI创作助手写篇文章吧