Limit of SQL, OFFSET

4 3;

The LIMIT 4 OFFSET 3 instructs the DBMS such as MySQL to return 4 rows of data from line 3rd (counting from 0 rows). The first number is the number of rows retrieved , and the second number refers to where to start .

MySQL and MARIADB support the simplified version of the limit 4 OFFSET 3 statement, which is limit 3, 4. With this syntax, the previous value corresponds to OFFSET, and then the value corresponds to limit .

Limit of SQL, OFFSET