`

mysql查重

 
阅读更多
select * from t_device where v_id='361'  and mac in (select mac from t_device where v_id='361' group by mac having count(mac)>1);
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics