select * from 表 where num in(select num from 表 group by num having count(num)>1)
转载于:https://www.cnblogs.com/yangjinwang/p/4309228.html
select * from 表 where num in(select num from 表 group by num having count(num)>1)
转载于:https://www.cnblogs.com/yangjinwang/p/4309228.html