怎么写select可以得到某几条符合规则的记录

[idoloveyou]

怎么写select可以得到某几条符合规则的记录
比如我想得到第5-8条记录，怎么写？

[pengdali]

select IDENTITY(int, 1,1) AS ID_Num,* into #temp from 表
select * from #temp where ID_Num between 10 and 20

[yujohny]

select top 4 from 表 where id= (select top 8 from 表 order by id)
order by id desc

[yujohny]

ID是表的主键
select top 4 * from 表 where id= (select top 8 from 表 order by id)
order by id desc

[idoloveyou]

子查询最多能返回一个记录

[gmlxf]

5-8这4条记录（降序）
select top 4 * from
(select top 8 * from 表 order by id) a
order by iddesc

5-8这4条记录（升序）
select * from
(
select top 4 * from
(select top 8 * from 表 order by id) a
order by id desc
) a
order by id

[gmlxf]

5-8这4条记录（降序）
select top 4 * from
(select top 8 * from 表 order by id) a
order by id desc

5-8这4条记录（升序）
select * from
(
select top 4 * from
(select top 8 * from 表 order by id) a
order by id desc
) a
order by id