SQL按字段查询重复数据并列出重复数据

例如：查询重复2次的数据并列出

select * from park_room where parkNum in (  
select parkNum from park_room  
group by parkNum  
having count(parkNum) > 1  
) order by parkNum  

字段信息说明： park_room--停车位表 parkNum--车位号

mysql查找重复记录sql语句

select mobilePhone,count(*) as count from xk_utd_house_basic group by mobilePhone having count>1;