常用的两种查询第几行的SQL语句

第一种：

with idTable as (
select ROW_NUMBER() over(order by EID desc) as rowID,* from dbo.Experience
)
select*from idTable where rowID between 1 and 10

第二种：

select top(10)*from Experience WHERE EID NOT IN (select top(10) EID from Experience) order by EID desc