select name,mobile from [GeneShop].[dbo].[xx_member] where mobile in ( SELECT mobile FROM [GeneShop].[dbo].[xx_member] group by mobile having COUNT (mobile) <> 1) order by mobile;
查询结果展示：
本文共 215 字，大约阅读时间需要 1 分钟。
select name,mobile from [GeneShop].[dbo].[xx_member] where mobile in ( SELECT mobile FROM [GeneShop].[dbo].[xx_member] group by mobile having COUNT (mobile) <> 1) order by mobile;
查询结果展示：
转载地址：http://idmyx.baihongyu.com/