SqlServer ²éѯÊý¾ÝÖظ´

SQL Server ²éѯÊý¾ÝÖظ´ 1¡¢²éѯµ¥ÁÐÖظ´ select * from test where name in (select name from test group by name having count (name) > 1) 2¡¢²éѯ¶àÁÐÖظ´ SELECT a.* FROM tes