oracle 行号和分页

2023-01-31 14:55:09

1.行号是个伪列，rownum 永远按照默认的顺序生成

SELECT r, e2.*

FROM (SELECT rownum AS r, e1.*

	FROM (SELECT *

		FROM emp

		ORDER BY sale

		) e1

	WHERE rownum <= 8

	) e2

WHERE r >= 5;