select * from `app_info`
where `app_code` in (select `app_code` from `app_info` group by `app_code` having count(`app_code`) > 1)
值得学习的sql
最新推荐文章于 2024-01-25 14:59:28 发布
select * from `app_info`
where `app_code` in (select `app_code` from `app_info` group by `app_code` having count(`app_code`) > 1)