查询数据库字段的重复出现 select * from `A` where `id` in (select `id` from `A` WHERE `s_id` = 5 group by `id` having count(1) >= 2)