SQL> select ename, job, sal from emp order by sal;
ename | job | sal
--------+-----------+------
SMITH | CLERK | 800
JAMES | CLERK | 950
ADAMS | CLERK | 1100
WARD | SALESMAN | 1250
MARTIN | SALESMAN | 1250
MILLER | CLERK | 1300
TURNER | SALESMAN | 1500
ALLEN | SALESMAN | 1600
CLARK | MANAGER | 2450
BLAKE | MANAGER | 2850
JONES | MANAGER | 2975
FORD | ANALYST | 3000
SCOTT | ANALYST | 3000
KING | PRESIDENT | 5000
(14 rows)
SQL> select ename, job, sal from emp order by sal limit 5;
ename | job | sal
--------+----------+------
SMITH | CLERK | 800
JAMES | CLERK | 950
ADAMS | CLERK | 1100
WARD | SALESMAN | 1250
MARTIN | SALESMAN | 1250
(5 rows)
SQL> select ename, job, sal from emp order by sal offset 0 limit 5;
ename | job | sal
--------+----------+------
SMITH | CLERK | 800
JAMES | CLERK | 950
ADAMS | CLERK | 1100
WARD | SALESMAN | 1250
MARTIN | SALESMAN | 1250
(5 rows)
SQL> select ename, job, sal from emp order by sal offset 5 limit 5;
ename | job | sal
--------+----------+------
MILLER | CLERK | 1300
TURNER | SALESMAN | 1500
ALLEN | SALESMAN | 1600
CLARK | MANAGER | 2450
BLAKE | MANAGER | 2850
(5 rows)
SQL> select ename, job, sal from emp order by sal offset 10 limit 5;
ename | job | sal
-------+-----------+------
JONES | MANAGER | 2975
FORD | ANALYST | 3000
SCOTT | ANALYST | 3000
KING | PRESIDENT | 5000
(4 rows)
참고 : https://www.postgresdba.com/bbs/board.php?bo_table=B10&wr_id=41
