1、表带主键
根据主键进行排序
获取第3-7条数据
SELECT top 5 *
FROM FinancialItem
where ID not in (select top 2 ID from FinancialItem)
order by ID desc
2、使用Row_Number()函数给每一行赋值一个序号。
如:ROW_NUMBER() Over (order by id desc),先根据ID降序排序,然后给每一行从1开始赋值
select top 2 *
from (select ROW_NUMBER() Over (order by id desc) as RowNumber, * from FinancialItem) A
where RowNumber > 2;