//公示
select * from (select ROW_NUMBER() OVER(Order by uid ) AS RowNumber,uid from tb_asset_kpdj) as b
where RowNumber BETWEEN (页数-1)*条数+1 and 页数*条数
//示例 以第一页为例
select * from (select ROW_NUMBER() OVER(Order by uid ) AS RowNumber,uid from tb_asset_kpdj) as b
where RowNumber BETWEEN (1-1)*50+1 and 1*50