代码:
select * from uav a where exists(
select sn_number from uav
where a.sn_number = sn_number
group by sn_number
having count(*) >=2
)
结果截图:
代码:
select * from uav a where exists(
select sn_number from uav
where a.sn_number = sn_number
group by sn_number
having count(*) >=2
)
结果截图: