declare @t table (id int,name varchar(20),level int)
insert into @t select 1,'a',3
union all select 2,'a',7
union all select 3,'a',9
union all select 4,'a',4
union all select 5,'b',4
union all select 6,'b',13
union all select 7,'c',13
union all select 8,'c',15select * from @t where level in(select level from @t group by level having count(*)>1)
insert into @t select 1,'a',3
union all select 2,'a',7
union all select 3,'a',9
union all select 4,'a',4
union all select 5,'b',4
union all select 6,'b',13
union all select 7,'c',13
union all select 8,'c',15select * from @t where level in(select level from @t group by level having count(*)>1)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货