RowNumber()分页方法

select
top 100 --每页显示数据记录数
contractid,contractName from (
select ContractId,ContractName,ROW_NUMBER() over(order by contractname desc) as rownum from CR_ContractBasic
)t where
t.rownum >5000 --每页显示数据记录数pagezie*第几页pagenum-1