select top 5 * from CustomerBusinessLicence where licenceid not in
如果是第一个第五页就是
select top 5 licenceid from CustomerBusinessLicence order by licenceid desc
sql2005里面有了row_number函数,那我们就用这个函数了
select * from (
select row_number() over(order by CreateTime desc) as rowNumber,*
from CustomerBusinessLicence
) A
where A.rownumber between 1 and 10