Is there any such sentence, please enlighten me

fangrui12

If I have an id now, I want to query the IDs that are adjacent to the id.

我是杀人狂

select top 2 * from tablename where id <specify id order by id desc
select top 2 * from tablenam where id> specify id order by id

cv4bf5d65fd

select top number * from tablename where id <id order by id desc
select top number * from tablename where id> query id order by id

fanfan1980

--try


select top N * from tbName where id <'' order by id desc
union all
select * from tbName where id = ''
union all
select top N * from tbName where id> '' order by id

hiqwolfzzh

select * from tablename
where
id in (select distinct top range number [id] from tablename where id <refer to id order by id DESC)
or
id in (select distinct top range number [id] from tablename where id> refer to id order by id ASC)

hiqwolfzzh

select * from #temp
where
[id] in (select distinct top Range number [id] from #temp where [id] <refer to id order by [id] DESC)
or
[id] = Reference id
or
[id] in (select distinct top Range number [id] from #temp where [id]> Refer to id order by [id] ASC)

hiqwolfzzh

create table #temp
(id varchar (50)
)
insert into #temp
select '1' union all select '2' union all select '3' union all select '4' union all select '5' union all select '6' union all select '7' union all select '8'
select * from #temp
----------------------
id
1
2
3
4
5
6
7
8


Two digits before and after query
select * from #temp
where
[id] in (select distinct top 2 [id] from #temp where [id] <5 order by [id] DESC)
or
[id] = 5
or
[id] in (select distinct top 2 [id] from #temp where [id]> 5 order by [id] ASC)
-------------
id
3
4
5
6
7