前提你已经知道此条的ID号,比如已经放到@id 中上一条--select top 1 * from (select * from table where id < @id) order by id desc下一条 --- select top 1 * from (select * from table where id > @id) order by id asc
select * from tablename where id = (select top 1 id from tablename where id>@id order by id) or id = (select top 1 id from tablename where id <@id order by id desc)
from (select * from table where id < @id)
order by id desc下一条
---
select top 1 *
from (select * from table where id > @id)
order by id asc
from tablename
where
id = (select top 1 id from tablename where id>@id order by id) or
id = (select top 1 id from tablename where id <@id order by id desc)