第一种:
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