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

Question

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

Answer 1

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

Answer 2

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