查询重复数据group by menu_id having count(menu_id)>1

select * from sys_power_menu WHERE menu_id in ( select menu_id from  sys_power_menu group by menu_id having count(menu_id)>1);select * from sys_power_menu WHERE menu_id in (