sqlserver 数据库分页
select * from (select *,ROW_NUMBER() OVER(ORDER BY(SELECT 0)) AS Rownum from employee) as table1 where table1.rownum >= 1 and table1.rownum <= 3
select * from (select *,ROW_NUMBER() OVER(ORDER BY(SELECT 0)) AS Rownum from employee) as table1 where table1.rownum >= 1 and table1.rownum <= 3