做个存储过程吧,如果时间有重复,那么就难以判断了:
select id=identity(int,1,1),* into #t from (select * from [table] order by timecolumn ) a
select * from #t where id between 10 and 20
select id=identity(int,1,1),* into #t from (select * from [table] order by timecolumn ) a
select * from #t where id between 10 and 20
(
select top 20 *
from table
order by [时间]
)a
order by [时间] desc
学习up
(
select top 20 *
from table
order by newid()
)a
order by [时间] desc
From F
Where F.ID NOT IN (Select Top 10 A.ID
From A
Order By A.CreateTime ASC) --表F中的ID不等于表A中的前10条
Order BY F.CreateTime ASC
select * from #temp where id > 10 and id < 21
drop table #temp