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

fangrui12

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

我是杀人狂

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

cv4bf5d65fd

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

fanfan1980

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

hiqwolfzzh

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)

hiqwolfzzh

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)

hiqwolfzzh

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