62,041
社区成员
发帖
与我相关
我的任务
分享
--写个参考,希望能有用。
create table tb(num int,no int)
insert into tb
select 1, null union all
select 2, null union all
select 3, null union all
select 4, null union all
select 3, null union all
select 2, null union all
select 1, null union all
select 2, null union all
select 3, null union all
select 4, null union all
select 5, null union all
select 6, null union all
select 7, null union all
select 6, null union all
select 5, null union all
select 4, null union all
select 3, null union all
select 4, null union all
select 5, null union all
select 6, null union all
select 5, null union all
select 4, null union all
select 3, null union all
select 4, null union all
select 5, null
declare @num1 int,@num2 int
set @num1=0
update tb set no=@num1,
@num1=(case when num>=@num2 then @num1 else @num1+1 end),@num2=num
select MIN(num)[min],MAX(num) [max] from tb group by no having COUNT(*)>1
/*
min max
----------- -----------
1 4
1 7
3 6
3 5