OFFSET start { ROW | ROWS }

FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } { ONLY | WITH TIES }

MariaDB [test]> select seq from seq_1_to_10 offset 5 rows fetch next 1 rows only;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows fetch next 1 rows only' at line 1

MariaDB [test]> select seq from seq_1_to_10 offset 5 fetch next 1 rows only;

+-----+

| seq |

+-----+

|   6 |

+-----+

1 row in set (1.250 sec)

create table t1 (pk int primary key);

insert into t1 values (1),(2),(3),(4);

select pk from t1 offset 2 rows fetch next 1 rows only;

✓

4 rows affected

pk

3

select pk from t1 offset 2 fetch next 1 rows only;

pk

3