limit offset

SELECT * FROM artists LIMIT 5 OFFSET 2;

SELECT * FROM artists LIMIT 5 OFFSET [Number of rows to skip];