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;
查询结果展示:
时间:2018-09-12 12:11:52
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;
查询结果展示:
Mysql数据库中查询重复数据和去重数据 删除重复数据的sql及分析
2020-07-31
SQL Server数据库表的基本操作(批量插入 删除 查询数据 删除表中重复数据方法)
2019-08-21