Select Name,ID From A group by Name,ID having count (*)>1 转载于:https://www.cnblogs.com/zuiyeqingfeng/p/3340329.html