查询分页

语法：

[ OFFSET offset { ROW | ROWS } ]

[ FETCH { FIRST | NEXT } [ { rowcount | percent PERCENT } ]

    { ROW | ROWS } { ONLY | WITH TIES } ]

create table test (id int);

SQL> select * from test order by id;

ID

----------

1

1

2

2

3

3

4

SQL> select * from test order by id OFFSET 1 rows; --移动一行

ID

----------

1

2

2

3

3

4

SQL> select * from test order by id OFFSET 1 rows fetch next 3 rows only;

ID

----------

1

2

2

SQL> select * from test order by  id FETCH next 50 percent rows only;

ID

----------

1

1

2

2

SQL> select * from test order by  id FETCH FIRST 3 row with ties;

ID

----------

1

1

2

2