关于sql server limit 在sql server中的转化？怎么实现呢？

Question

select *From exerciseorder by Eidlimit 10,10 请问再sql server 2012中用top怎么能实现此语句？

Answer 1

select * from
(select row_number() over (order by Eid) as rn,*
from
exercise)
where rn between 10 and 19

Answer 2

select top 10 * from exercise
where Eid not in(select top 9 Eid from exercise order by Eid)
order by Eid