不好意思,没分了,可不可以问个问题啊?帮下忙啦

[loveme2000ok]

一张表,如下一个字段,数据为虚拟的:
ID
1
3
6
8
9
10

我现在知道ID=8的这条记录,现在想取出6和9,即8两边的那两记录
同理ID=9时,应该取出8和10两条记录,谢谢!

[loveme2000ok]

顶一下,帮一下忙!

[九斤半]

create table test (ID int)
insert test values (1)
insert test values (3)
insert test values (6)
insert test values (8)
insert test values (9)
insert test values (10)
--select * from test
go

create proc pTest
@id int
as
begin
select * from test
where
id=(select max(id) from test where id<@id)
or
id=(select min(id) from test where id>@id)
end
go

--我现在知道ID=8的这条记录,现在想取出6和9,即8两边的那两记录
exec pTest 8

drop proc pTest
drop table test

[hyrongg]

select max(id) from test where id<8
union
select min(id) from test where id>8

[itblog]

select * from tablename
where
(id =(select max(id) from tablename where id<8))
or
(id =(select min(id) from tablename where id>8))

[Well]

select *,identity(int,1,1) #temp from tableName

select * from #temp
where TID=((select TID from #Temp where id=8)-1)
or TID=((select TID from #Temp where id=8)+1)
drop table #temp