SQL查询重复值

查询数据库字段的重复出现

select * from `A` where `id` in (select `id` from `A` WHERE `s_id` = 5 group by `id` having count(1) >= 2)