正所谓前人栽树，后人乘凉。 感谢Huxpro提供的博客模板,同时也感谢BY!
select top 10 A.orderid,A.pay,A.pay_date,A.pay_time,A.machineId,A.sysflag
from (
select ROW_NUMBER()over(order by orderid desc) as rownumber,*
from (select * from XC_month )as xc
)as A
where rownumber>1*10
and A.orderid like '%Fk%'
后台只需要传当前页和每页的显示数量
