代码如下: –建立数据表createtable TestData ( ID int identity(1,1) primary key, Data int, ColA varchar(20), ColB varchar(20) ) go –插入测试数据 declare @counts int declare @i int set @counts = 10000 ...
开发背景: ...使用SQL语句查询重复的数据有哪些: SELECT * from brand WHERE brandName IN( select brandName from brand GROUP BY brandName HAVING COUNT(brandName)>1 #条件是数量大于1的重