一·
select * from (
select *,ROW_NUMBER() OVER (ORDER BY EMPNO) as rank from emp
) as t where t.rank between 11 and 14
(页码始) (页码末)
二·
select top 10 * from emp where EMPNO not in(select top (10*(页码-1)) EMPNO from emp)
一·
select * from (
select *,ROW_NUMBER() OVER (ORDER BY EMPNO) as rank from emp
) as t where t.rank between 11 and 14
(页码始) (页码末)
二·
select top 10 * from emp where EMPNO not in(select top (10*(页码-1)) EMPNO from emp)