Select Name,COUNT(*) as theName FROM TABLE GROUP BY Name HAVING COUNT(*) >=2 ORDER BY theName; 转载于:https://www.cnblogs.com/zwl12549/archive/2007/08/16/858963.html