select IDENTITY(INT,1,1) AS rownum,a.* INTO #TEMP from users a where [date]>'2002-10-10' order by [date]>desc
select * from #TEMP where rownum>=10 and rownum<=15
select * from #TEMP where rownum<=10
drop table #TEMP
select * from #TEMP where rownum>=10 and rownum<=15
select * from #TEMP where rownum<=10
drop table #TEMP
select * from #TEMP where rownum>=10 and rownum<=15
select * from #TEMP where rownum<=10
drop table #TEMP
select * top 10 from users where [date]>'2002-10-10' order by [date]
只能选前10条,不能满足我的要求。