下面这个是测试语句，你自己看一下是不是符合你自己的要求，符合的话自己修改一下好了

begin tran
create table #temp
(
aaa int,
bbb varchar(10)
)

insert into #temp
select 1, 'test-a'
union
select 2, 'test-b'
union
select 3, 'test-b'
union
select 5, 'test-a'
select *
from #temp

select a.*
from #temp a
inner join
#temp b
on a.bbb=b.bbb
where a.aaa=b.aaa-1
union all
select b.*
from #temp a
inner join
#temp b
on a.bbb=b.bbb
where a.aaa=b.aaa-1
rollback tran