到底有没有这样的语句 请高手赐教

[wind513]

假如我现在有一个id 我想查询和id邻近的几个id 前后都可以

[caixia615]

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

[leo_lesley]

select top 个数 * from tablename where id<查询的id order by id desc
select top 个数 * from tablename where id>查询的id order by id

[marco08]

--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

[rookie_one]

select * from tablename
where
id in(select distinct top 范围数 [id] from tablename where id<参照id order by id DESC)
or
id in(select distinct top 范围数 [id] from tablename where id>参照id order by id ASC)

[rookie_one]

select * from #temp
where
[id] in(select distinct top 范围数 [id] from #temp where [id]<参照id order by [id] DESC)
or
[id]=参照id
or
[id] in(select distinct top 范围数 [id] from #temp where [id]>参照id order by [id] ASC)

[rookie_one]

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


查询前后两位ID
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

[wind513]

多谢大家帮忙， 分少了， 给不过来啊！

[rookie_one]

给点就行了，快揭帖把，呵呵

[L5160729]

学习

[十一月猪]

呵呵 方法全了