需求:根据ID排序后分页,每页10条记录,显示第二页 SELECT * FROM ( SELECT ROWNUM rn, T.* FROM ( SELECT s.* FROM something s ORDER BY sth ) T WHERE -- 结束位置 ROWNUM < 21 ) WHERE --开始位置 rn > 10