基于CTE分页
1)、用row_number()排名函数,派生表的方式分页
select *
from ( select p.*, rownum rnum
FROM (
SELECT ROW_NUMBER() OVER(ORDER BY appealId) AS rowNum, *
FROM appeal (NOLOCK)
) p
where rownum <= 20
) z
where rnum >= 10
from ( select p.*, rownum rnum
FROM (
SELECT ROW_NUMBER() OVER(ORDER BY appealId) AS rowNum, *
FROM appeal (NOLOCK)
) p
where rownum <= 20
) z
where rnum >= 10