没有ID时先:select identity(int,1,1) as id,* into #temp from table order by col select * from #temp where id=10000
select IDENTITY(int, 1,1) AS ID_Num,* into #temp from 表 select * from #temp where ID_Num>10 and ID_Num<=20
exec('SELECT Top '+cast(@PageSize as varchar)+' * FROM T WHERE SortField NOT IN (SELECT TOP '+cast(@PageSize* @Pagei as varchar)+' SortField from T )')
select * from #temp where id=10000
select * from #temp where ID_Num>10 and ID_Num<=20
pengdali(大力) 第一条(无ID)结果与CrazyFor(蚂蚁)无ID时结果一样.