select * from 表 where id in (select top 2 id from 表 where id<@id order by id desc) or id in (select top 2 id from 表 where id>@id order by id) order by id
---可以实现 select * from Tablename where Id in( select Top 2 Id from Tablename where Id>@id order by Id asc) union select * from Tablename where Id in( select Top 2 Id from Tablename where Id<@id order by Id desc) union
where id in (select top 2 id from 表 where id<@id order by id desc)
or
id in (select top 2 id from 表 where id>@id order by id)
order by id
select * from Tablename where Id in( select Top 2 Id from Tablename where Id>@id order by Id asc)
union
select * from Tablename where Id in( select Top 2 Id from Tablename where Id<@id order by Id desc)
union