sql server 查询，表中有多少条重复记录

比如，商城得用户地址表，想要知道该表中各个省得数量

SELECT 
      [province_id]
    
,count(*)
  FROM [dbo].[ws_address] group by [province_id] 

 

 

要搜索出省得名称

SELECT 
      (select [name] from ws_region where id = [province_id]) as proname
    
,count(*) as chongfu
  FROM [YMYP_Shop].[dbo].[ws_address] group by [province_id]