select * from [tableName] where [rowName] in(SELECT [rowName] from [tableName] GROUP BY [rowName] HAVING COUNT([rowName])>1) ORDER BY [rowName] ASC
mysql查询重复数据
最新推荐文章于 2024-07-19 09:36:46 发布
select * from [tableName] where [rowName] in(SELECT [rowName] from [tableName] GROUP BY [rowName] HAVING COUNT([rowName])>1) ORDER BY [rowName] ASC