sql server分页查询
–pageSize 每页显示的数量 100
–pageIndex 起始索引 1
select top 100 *
from (select row_number() over(order by FEmpID asc) as rownumber,*
from tbl_baseinfo) temp_row
where rownumber>((1-1)*100);
select top 100 *
from (select row_number() over(partition by FDept order by FEmpCode asc) as rownumber,*
from tbl_baseinfo) temp_row
where FDept=‘生产计划部’ and rownumber>((1-1)*100);