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;