查询数据库某个字段相同值的出现次数大于两次的列表

代码：
select * from uav a where exists(
select sn_number from uav
where a.sn_number = sn_number
group by sn_number
having count(*) >=2
)

结果截图：