select xm from tableName where xm in (select xm from tableName group by xm having count(1) >= 2) 方法简单粗暴