SQL> select ID from TBL rows 100 to 100;

ID

===============================================================================
100
SQL>

SQL> select ID from TBL rows 102 to 100;

ID

===============================================================================
Statement failed, SQLSTATE = HY000
Invalid parameter to FIRST.  Only integers >= 0 are allowed.
SQL>

SQL> select ID from TBL rows 101 to 100;
SQL>

select first(0) skip(100) ID from TBL;