declare @id int
set @id=10
select isnull((select max(id) from news where id<@id),0) as '上一个',
isnull((select min(id) from news where id>@id),0) as '下一个'
SQL中 得到相邻的上一个和下一个ID
最新推荐文章于 2023-06-15 14:13:30 发布
declare @id int
set @id=10
select isnull((select max(id) from news where id<@id),0) as '上一个',
isnull((select min(id) from news where id>@id),0) as '下一个'