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