Sysntax
[OFFSET offset { ROW | ROWS } ]
[ FETCH { FIRST | NEXT } [ { rowcount | percent PERCENT }]
{ ROW | ROWS } { ONLY | WITH TIES } ]x
e.g.
SELECT rownum, username FROM dba_users ORDER BY 2
FETCH FIRST 1 ROW ONLY;
FETCH FIRST 5 ROWS ONLY;
FETCH FIRST 5 ROWS WITH TIES;
FETCH FIRST 20 PERCENT ROWS ONLY;
OFFSET 1 ROW;
OFFSET 4
ROWS;
OFFSET 4 ROWS FETCH NEXT 1 ROW ONLY;
OFFSET 4
ROWS FETCH NEXT 4 ROWS ONLY;
OFFSET 4 ROWS FETCH NEXT 20 PERCENT ROWS ONLY;
