select limit and offset code example
Example 1: limit offset
SELECT * FROM artists LIMIT 5 OFFSET 2;
Example 2: limit offset
SELECT * FROM artists LIMIT 5 OFFSET [Number of rows to skip];
SELECT * FROM artists LIMIT 5 OFFSET 2;
SELECT * FROM artists LIMIT 5 OFFSET [Number of rows to skip];