例如
select top 20 * from table order by dId asc
然后用结果表获取这个表排行最后的10行(顺序和结果表一样),有没有和top一样的现成函数。
我只想到slect * from (select top 10 from (select top 20 * from table order by dId asc) order by dId desc) order by dId asc谢谢!
select top 20 * from table order by dId asc
然后用结果表获取这个表排行最后的10行(顺序和结果表一样),有没有和top一样的现成函数。
我只想到slect * from (select top 10 from (select top 20 * from table order by dId asc) order by dId desc) order by dId asc谢谢!
from(select *,row=row_number()over(order by did asc) from table)t
where row between 11 and 20--取记录
SQL 2005以上版本
;with cte
as
(select top 20 *,rid = row_number() over (order by did asac)
from table)
select *
from cte
where rid between 11 and 20