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
原文：http://www.cnblogs.com/sucessing/p/4696497.html