一旦我解决了以下查询:

once i solved such query as:

with cte as (
 SELECT * ,
  ROW_NUMBER () over (order by CountryId ) as rn
 FROM Country )
SELECT * FROM cte
WHERE rn>10 ;

这里的CountryId只是表的主键

here CountryId is just the primary key of the table