Create Table #Temp ( col1 int, col2 int, col3 int )Insert Into #Temp values(1,2,3) Insert Into #Temp values(3,2,1) Insert Into #Temp values(2,1,3) Insert Into #Temp values(1,2,3) Insert Into #Temp values(1,2,3) Insert Into #Temp values(2,1,3) Select * from #tempSelect col1, col2,col3,'行数'=Count(*) from #temp Group By col1, col2,col3
Create Table #Temp ( col1 int, col2 int, col3 int )Insert Into #Temp values(1,2,3) Insert Into #Temp values(3,2,1) Insert Into #Temp values(2,1,3) Insert Into #Temp values(1,2,3) Insert Into #Temp values(1,2,3) Insert Into #Temp values(2,1,3) select (cast(col1 as varchar(2))+cast(col2 as varchar(2))+cast(col3 as varchar(2))) col,count(1) 个数 from #temp group by cast(col1 as varchar(2))+cast(col2 as varchar(2))+cast(col3 as varchar(2))
select q1,q2,q3,count(*) as 记录数 from 表名 group by q1,q2,q3 having count(*)>=1就可以了谢谢楼上的同学们
(
col1 int,
col2 int,
col3 int
)Insert Into #Temp values(1,2,3)
Insert Into #Temp values(3,2,1)
Insert Into #Temp values(2,1,3)
Insert Into #Temp values(1,2,3)
Insert Into #Temp values(1,2,3)
Insert Into #Temp values(2,1,3)
Select * from #tempSelect col1, col2,col3,'行数'=Count(*) from #temp Group By col1, col2,col3
Create Table #Temp
(
col1 int,
col2 int,
col3 int
)Insert Into #Temp values(1,2,3)
Insert Into #Temp values(3,2,1)
Insert Into #Temp values(2,1,3)
Insert Into #Temp values(1,2,3)
Insert Into #Temp values(1,2,3)
Insert Into #Temp values(2,1,3)
select (cast(col1 as varchar(2))+cast(col2 as varchar(2))+cast(col3 as varchar(2))) col,count(1) 个数 from #temp group by cast(col1 as varchar(2))+cast(col2 as varchar(2))+cast(col3 as varchar(2))