总共两种方法
第一种
select top 1 * from (select top N * FROM <span style="font-family: Arial, Helvetica, sans-serif;">TableName </span>order by ID asc)as A order by A.ID desc
第二种
使用 row_number() over()
SELECT * from (select *,ROW_NUMBER()over(order by ID)as num FROM TableName)as B where B.num=N
亲测可行。