求教，SQL Server中如何返回指定的第n到m行的记录？或查询时自动添加行号？

[kaienli]

例如，我只想要按时间排序后的第5到底10行记录？

[NinGoo]

参考
http://community.csdn.net/Expert/topic/3666/3666152.xml?temp=.3363306

[Frewin]

Select a.*,(Select Count(*) As id from t where t.日期<=a.日期) as fid from t a
Where (Select Count(*) As id from t where t.日期<=a.日期) Between 5 and 10
order by a.日期

[didoleo]

select * from test a
where (select count(*) from test where 时间字段<=a.时间字段) in(5,10)

[haoli_004]

create table aa([ID] [int] IDENTITY (1, 1) NOT NULL ,查询表cc中的所有字段)

insert into aa(查询表cc中的所有字段)select cc.字段 from 查询表cc order by [time]

select aa.(查询表cc中的所有字段) from aa where [id]>4 and [id]<11

drop table aa